VBA to accept pasting current named ranges into defined ranges

[phpolicylady]

I have a macro that is copying data from one sheet in one workbook into another workbook. Both of these workbooks contained the same named ranges.

I am using the following code:

Please Login or Register  to view this content.

This works perfectly, but I get the annoying message boxes asking if it's ok to use the destination named references for each of the named ranges I have. I tried recording a macro watching me run through the other macro and clicking the "OK" box every time it popped up, but my recorded macro was totally blank.

I'm sure there is some syntax I can add on to the end of my code that will tell excel to ignore the named ranges from the EL workbook...right?

[LJMetzger]

See the following thread which answers a similar question: http://www.mrexcel.com/archive/VBA/22414.html

It involves using:

Please Login or Register  to view this content.

Lewis

[phpolicylady]

just exactly what i wanted!

thanks!