MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Copy named range from 1 file to another


Posted by Paul on December 11, 2001 1:12 PM

Hi,
I have 2 spreadsheets that contain the same named range. I need to copy the named range values from 1 to the other.

Does anyone have the VBA coded needed to perform this function.

Thanks,
Paul


Posted by Jacob on December 11, 2001 3:38 PM

Maybe this will help

This might help.

Sub Copyit()

application.screenupdating=false
sheet("my sheet name").activate
range("my named range").select
selection.copy
sheet("my other sheet name").activate
range("my named range").select
active sheet.paste
application.cutcopymode=false


end sub

Hope this helps

Jacob

Posted by Paul on December 12, 2001 9:17 AM

Re: Maybe this will help

Thanks, it worked great!