Thread: 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

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

Regards,
Simon