Sheet name

  • Thread starter Thread starter oldjay
  • Start date Start date
O

oldjay

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

MyConstant = Application.CountA(Sheets("Master").Range("A2:I31"))
 
I want to change this from the Master sheet to the active sheet

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


Try this:

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

Hope this helps/ Lars-Åke
 
Try this...

MyConstant = Application.CountA(ActiveSheet.Range("A2:I31"))
 
Replace Sheets("Master") with ActiveSheet
eg.
MyConstant = Application.CountA(activesheet.Range("A2:I31"))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

copying columns 3
Macro to Compile Data from Different Sheets 2
Macro to Combine Data from Multiple Sheets with Cell References 4
Error Message - Macro to Unlink MS Queries from Workbook 0
Save record Into master sheet! 1
hide multiple worksheets based on a formula value in one cell 1
Run macro from active workbook whose name keeps changing 20
Insert Row also adds formulas and moves cursor 2

Back
Top