Paste Question

[Guest]

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

 

[Tom Ogilvy]

DestSh must be the activesheet if you are going to select a range within
that sheet.

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

Of course you can do a copy and paste without selecting the destination
range.

Other problems might be that your code alters something that clears the
clipboard before you get to your paste command although there is nothing in
the code you show that involves either a copy or a paste.