Thread: Sheet name
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Rob van Gelder Rob van Gelder is offline
external usenet poster
  
Posts: 37
Default 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" ))
Reply With QuoteReply With Quote