View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default VBA Code to copy values &formats to the next worksheet

After the paste, do

Application.CutCopyMode = False

--
Regards,
Tom Ogilvy


"MSama" wrote in message
ups.com...
I think I have it. I got the idea from another entry in this group,
that if i record a macro with the action I want to automate, I can then
look at the code that was generated - brilliant!

Thanks anyway!

-Marco