Thread: Paste Question
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default Paste Question

I just can't figure out how to paste something that I've previously copied
into this selection. I've confirmed that last+1 and Last1 are real values.
DestSh is also not always the active sheet.

DestSh.Range("A" & Last + 1 & ":" & "A" & Last1).Select

I'm sure someone out there in the ether knows exactly what to do.

Thanks,
Barb