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