ExcelBanter - Macro statement

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Macro statement (https://www.excelbanter.com/excel-programming/275844-macro-statement.html)

sheela

Macro statement

Hi,

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

Application.Goto Reference:="mthProdDateRange"

Thanks,

sheela

Richard Daniels

Macro statement

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'

-----Original Message-----
Hi,

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

Application.Goto Reference:="mthProdDateRange"

Thanks,

sheela
.

All times are GMT +1. The time now is 02:41 AM.