Posted to microsoft.public.excel.programming
|
|
Jump to "Defined name" range!
Try that from another sheet.
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"Don Guillett" wrote in message
...
just like if it wasn't named
Sub gotomynamedcells()
Range("mynamedcell").Select
End Sub
--
Don Guillett
SalesAid Software
wrote in message
ps.com...
Hi,
I need help on how to jump to a "defined name" cell using vba. Please
help!! Lets say that a defined name cell is "COST" fo cell A10, how
could I write a code to select that cell based on the defined name ?
Thanks
Tim,
|