Alan McQuaid via OfficeKB.com
Guest
Re: Copy worksheet, rename, merged cell problem??
Simon,
At the end of the line "Selection.PasteSpecial Paste:=xlPasteValues,
Operation:=xlNone," you need to place _ to get this part to work
Alan
Simon Lloyd wrote:
>Hi all, i have some code below that i have put together to copy a
>worksheet using the sheet name and some text and the value in A1 i
>havent got it to run right the way through yet it stops at the
>Selection.PasteSpecial line in the code.....any ideas?
--
Message posted via http://www.officekb.com
Bookmarks