Simple question - Named Range in Macro

[wammer]

How do I create a macro to go to a sheet and a certain cell that i
named?

Range ("Name").Select was what i thought, but that does not work.

thanks
Ca

 

[Stephen Rasey]

Application.Goto "namedrange"

Range("name").select only works when target range is on the active
worksheet.

Stephen Rasey
Houston
http://wiserways.com
http://excelsig.org