Is there way to refer to a Named/Defined range within a macro?

[jnathan]

I have created a number of worksheets that have defined names e.g. a named range called ASX with the following formula...

=ASX!$A$1:INDEX(ASX!$AE:$AE,COUNTA(ASX!$AE:$AE),1)

Is there a way to refer to this range within a macro so that I can copy the range and paste it into a new workbook?

Many thanks for your help!

J

 

[Joe4]

First off, I wouldn't name your range the exact same name as your worksheet. That will only cause confusion.

If you are already on the sheet where your named range exists, you can select it like this:

    Range("MyRange").Select

where "MyRange" is the name of your named range.

If it is on a different sheet, you will need to activate/reference that sheet:

    Sheets("Sheet2").Select
    Range("MyRange").Select

 

[jnathan]

Many thanks for your help and suggestions!!!