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:
EL.[C2:AA54].Copy Destination:=EL2[C2:AA54]
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?