Named ranges on multiple sheets

[jsneak]

Morning all,

Wondering if someone could help me with this subject. Basically i have two sheets with the same named ranges (lets say 1,2 and 3) I have a macro that copies the data from the named ranges into a database (sheet3)... However, on Sheet2 when i use the macro, it copies the named ranges from Sheet1 and not sheet2...

Any ideas?!

Thanks in advance!

[Tnashnhsp1]

are you specifying the sheet names when copying the named range? It should be

Please Login or Register  to view this content.

for sheet 1, and for named ranges in sheet 2

Please Login or Register  to view this content.

[YasserKhalil]

Suppose you have named range with "Data" in both sheet1 and the same named range in sheet2
Try this code

Please Login or Register  to view this content.

or you can replace activesheet with the target sheet

Please Login or Register  to view this content.