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 Copying values not formulas

here = there

--
Regards,
Tom Ogilvy

"Joe M." wrote in message
...
I have the following piece of code

Here.EntireRow.Copy Destination:=There

This copies the formulas that are in this row, I need to
know how to modify this code to copy values instead of
formulas.

Any help?