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
.