Sheet name
Thanks again for the help
"OssieMac" wrote:
MyConstant = Application.CountA(ActiveSheet.Range("A2:I31"))
--
Regards,
OssieMac
"oldjay" wrote:
I want to change this from the Master sheet to the active sheet
MyConstant = Application.CountA(Sheets("Master").Range("A2:I31" ))
|