syntax to go to a named range
Hi Ben,
If the named range is on the active sheet, try:
Range("MyNameRange").select
---
Regards,
Norman
"Ben" wrote in message
...
Hi all,
I record a macro in Excel to go to a particular name name. It produced
something like this:
Application.Goto Reference:="MyNameRange"
Do you know of a shorter syntax? It just seems to be a long line, since I
have many name ranges. Thanks.
Ben
--
|