Macro statement

  • Thread starter Thread starter Sheela
  • Start date Start date
S

Sheela

Hi,

Is this a correct statement. I'm running in excel 2000.

Application.Goto Reference:="mthProdDateRange"

Thanks,

sheela
 
Hi Sheela

Yes this will work in a sub only if you have a named
range called mthProdDateRange. Else ir will return a
1004 runtime error 'reference not vaild'
 
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

Excel Macro error 3
Updating data automatically using macro 2
Excel VBA Macro 4
Macro needs updated Range name addresses 3
writing the column names in first row, based on the sheet name 4
"Runtime error 1004 Application-defined or object defined error" on data sort 0
Dynamic Offset from an Application.Goto cell = Date or Time 10
Need a loop in my macro 2

Back
Top