View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Hide the selected range highlighter

Is this the same thing you were working on? If so, the code doesn't select.

If you want to do it with the clipboard, you can't remove the marque without
loosing the range in the clipboard.

after the copy, you can do

Application.CutCopyMode = False

--
Regards,
Tom Ogilvy

wrote in message
oups.com...
I have a vba loop that runs and copy/pastes ranges. Is it possible to
hide the range selection during the copy/paste procedure?