Thread
:
Sheet name
View Single Post
#
5
Posted to microsoft.public.excel.programming
OssieMac
external usenet poster
Posts: 2,510
Sheet name
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" ))
Reply With Quote
OssieMac
View Public Profile
Find all posts by OssieMac