In this article I am going to write an User Defined Function (UDF) which is used to remove all HTMLs from a String Stored in Cell. It can be used as normal Inbuilt Formulas of Excel. For writing this function i have used VBScript Regular Expression to Replace all the...
Results for "cell"
References In Excel Formulas – Absolute and Relative
This article is not about Excel Macro but this is about Absolute and Relative References in Excel formula. In Excel Formulas, as you have seen, for referring any cell, we use the Address (Reference) of that Cell like A1, B2 etc. This is called Cell Reference in Excel....
Excel Macro Tutorial : VBA Spin Button
In the previous Article How to write Excel Macro - Your First Excel Macro of Excel Macro Tutorial, you have seen how to write Excel Macro. Also in Previous Tutorials, you have seen all the basic concept of Excel Macro. In this Article I am going to show you how to Add...
How to Disable Right Click in Excel Workbook
Some times for some security reason or some other reason, you want to disable right click on the Workbook or Worksheet or on a particular Cell or Cell Range. 1. Disable Right Click on Whole Workbook 2. Disable Right Click on whole WorkSheet 3. Disable Right Click on a...
COUNT and COUNTA Function
COUNT(): COUNT is a Excel inbuilt formula. It takes CELL RANGE as an input and give the total count of the Cells which are having Numeric Values. Important: COUNT counts only those cells which are having "Numeric" Values. It ignores those cell which are having...
Excel Macro Tutorial : How to write Excel Macro – Your First Excel Macro
Dear Readers, Till now we have learnt following things in Excel Macro Tutorial . In this part of Tutorial you are going to learn how to open the VBE Code Window in Visual Basic Editor of your Workbook and start writing your first macro. 1. What is Excel...
How to Create Drop Down List in Excel
Drop down list is made in Excel Cell to limit the Entry in to a Cell from a predefined set of values. It means you are restricted to select one value out of set of Predefined values. On creating a drop down list on a cell or cell-range, one drop-down will be displayed...
File Name Formula
There are few instances when we want to store the File Name or Current Workbook Name in a particular Cell. This is very easy. This can be done by using Cell() function as shown below: Syntax: =CELL("filename") Returned Value: C:\Users\Vish\Desktop\[Test.xlsx]Sheet1...
How to Edit Existing Conditional Formatting
For editing Conditional Formatting of an Excel Workbook, follow following steps. It is different for Excel 2003 and 2007. So we will see the steps for both Excel 2003 and 2007. Excel 2007 || Excel 2003 Excel 2007: a) When you know the cell or cell range where that...
Conditional Formatting in Excel
Conditional Formatting in Excel: In MS Excel we can do formatting of cells based on some conditions or values. This is called Conditional formatting. For example, if you want a cell color to be red whenever the Value in the Cell is updated as "FAILED" or "Less Than...
Buy a coffee for the author
Download FREE Tools and Templates
There are many cool and useful excel tools and templates available to download for free. For most of the tools, you get the entire VBA code base too which you can look into it, play around it, and customize according to your need.
What is Excel Formula?
Excel Formula is one of the best feature in Microsoft Excel, which makes Excel a very very rich application. There are so many useful built-in formulas available in Excel, which makes our work easier in Excel. For all the automated work, Excel Macro is not required. There are so many automated things can be done by using simple formulas in Excel. Formulas are simple text (With a Syntax) which is entered in to the Excel Worksheet Cells. So how computer will recognize whether it is a formula or simple text? Answer is simple.. every formula in Excel starts with Equal Sign (=).
What is Pivot Table ?
As you know Excel has so many excellent features in it. Pivot Table is one of them. If you use Microsoft Excel and not...
Download Free File Manager – New Version
Hi Friends, I had created one file manager in Excel using excel macro. Basically it lists all the Files in a folder...
Download : Excel Macro Application to Send Multiple Emails
Hello Friends, I was getting queries on : How to send Email from Excel ? How to send Email from Gmail in Excel Macro ?...