Friday, December 10, 2010

Check cell is Having Formula or Not

Userdefine function to check the cell is having formula or not:-

Function checkformula(x As Range)
checkformula = x.HasFormula

End Function


Suppose if you want to check cell "D1" is having formula or not

You need to type =checkformula(d1)

It will return TRUE if having formula and FALSE if not.
at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Import data from SQL

Macro to import data from SQL using ADO connection string: Sub Import_data_from_SQL() ' Tools -> References -> Microsoft Active...

  • Copy Data from PDF to Excel Using Send-keys
    If you want to copy the data from pdf file to Excel. Sub method1_using_sendkey() Dim task ' open the file ' change the path of ...
  • Import data from SQL
    Macro to import data from SQL using ADO connection string: Sub Import_data_from_SQL() ' Tools -> References -> Microsoft Active...