Sheet name
 

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

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

Sheet name
 

On Sat, 12 Dec 2009 12:08:01 -0800, oldjay
wrote:


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

Sheet name
 

Try this...

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

--
Rick (MVP - Excel)


"oldjay" wrote in message
...

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

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

Sheet name
 

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


On 13-Dec-2009 09:08, oldjay wrote:
MyConstant = Application.CountA(Sheets("Master").Range("A2:I31" ))

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" ))

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" ))