Userdefine function to check the cell is bold or not:-
Function checkbold(xa As Range)
checkbold = xa.Font.Bold
End Function
Suppose if you want to check cell "D1" is bold or not
You need to type =checkbold(d1)
It will return TRUE if bold and FALSE if not.
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...
-
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 ...
-
Macro to import data from SQL using ADO connection string: Sub Import_data_from_SQL() ' Tools -> References -> Microsoft Active...
Hi Alex
ReplyDeleteIts working fine in Excel 2007. which version you are using. Also are you using to check the cell value or text on shape .