View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Greg[_21_] Greg[_21_] is offline
external usenet poster
 
Posts: 8
Default Copy via code from a dynamic range using offeset

Sorry - me again.

I noticed that it is pasting cell contents versus values. How would I
keep the code in the simple one line and have it past values?

I guess I could split it to a copy and then a pastvalues line, but I
like it in one command.

Thanks again.