CODEWITHSUNDEEP
vbaexcel
ln29st
ln29st

Reputation: 83

Excel VBA Paste Values with Offset

How do I paste values from E2:AJ11 into the active cell on another worksheet?

I.e. the user selects a cell on Worksheet2 > VBA copies E2:AJ11 from Worksheet1 and pasts everything into that cell.

The following VBA pasts everything starting A1 into Worksheet2, but I need it to paste into the active cell. 

Sub Paste()

Worksheets("WS1").Range("E2:AJ11").Copy Destination:=Cells(ActiveCell.Row + 1, 1)

End Sub

Thanks so much!

Upvotes: 0

Views: 1570

Answers (1)

QHarr
QHarr

Reputation: 84475

Select your cell where you want to paste and press button.

Code would have copy ActiveCell at end i.e.

Worksheets("WS1").Range("E2:AJ11").Copy ActiveCell

Upvotes: 3

Related Questions