I am trying to select and copy a named range based on the value of a
particular cell.

For example

Range C1:C4 contain 4 cities in Australia and is named AUS_CITIES
Range D1:D4 contain 4 cities in the USA and is named USA_CITIES

The user enters his country in Cell A1: - lets say he enters
"Australia".

Based in the value of A1 (Australia) the macro should select the
range AUS_CITIES and copy this range to another worksheet.

Can anybody help me writing the VBA code for this ??

(the actual work that I need to do is a but more complex than this,
but the above example simplifies the issue at hand).

Many thanks for your help.

Wim