Sheet name

oldjay · Dec 12, 2009

I want to change this from the Master sheet to the active sheet

MyConstant = Application.CountA(Sheets("Master").Range("A2:I31"))

Lars-Åke Aspelin · Dec 12, 2009

I want to change this from the Master sheet to the active sheet

MyConstant = Application.CountA(Sheets("Master").Range("A2:I31"))

Try this:

MyConstant = Application.CountA(ActiveSheet.Range("A2:I31"))

Hope this helps/ Lars-Åke

Rick Rothstein · Dec 12, 2009

Try this...

MyConstant = Application.CountA(ActiveSheet.Range("A2:I31"))

Rob van Gelder · Dec 12, 2009

Replace Sheets("Master") with ActiveSheet
eg.
MyConstant = Application.CountA(activesheet.Range("A2:I31"))

OssieMac · Dec 12, 2009

MyConstant = Application.CountA(ActiveSheet.Range("A2:I31"))

oldjay · Dec 13, 2009

Thanks again for the help

OssieMac said:
MyConstant = Application.CountA(ActiveSheet.Range("A2:I31"))