Goto a named range using the contents of the active cell
 

I need a VBA macro that will allow me to use the cell contents of the current
active cell to select a predefined range that exists somewhere in the active
worksheet.

For example, cell a1 includes the text 'ABC'. There is a range in the
worksheet named 'ABC'. I need to select this range using the contents in
cell a1.

Thanks

Goto a named range using the contents of the active cell
 

This should be what you need!
Application.Goto Reference:=Range("A1").Value

Regards,
Simo

--
Simon Lloy
-----------------------------------------------------------------------
Simon Lloyd's Profile: http://www.excelforum.com/member.php...nfo&userid=670
View this thread: http://www.excelforum.com/showthread.php?threadid=55173