Thread: Sheet name
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein Rick Rothstein is offline
external usenet poster
  
Posts: 5,934
Default 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" ))

Reply With QuoteReply With Quote