Macro to Copy and Paste to a Variable Range

[pliskers]

I am having trouble with VBA code that will copy from a fixed range (A3 to L3 in my spreadsheet) to a range that varies from use to use. The Paste To range will always start with A6 to L6, but will go down a varaible number of rows that may be derived by performing an End-Down in column M.

Here's some code that I'm playing with (I'm a VBA newbie) but it's bombing out.

RowNum = Cells(65536, 14).End(xlUp).Row
ColNum = Cells(16, 14).Column


Range("A3:L3").Select
Selection.Copy
Range("A6:" & (RowNum ColNum)).Select
ActiveSheet.Paste
Application.CutCopyMode = False
End Sub

Any suggestions?

 

[Datsmart]

Hi pliskers

Try this:

RowNum = Cells(65536, "M").End(xlUp).Row
Range("A3:L3").Copy Destination:=Range("A6:L" & RowNum)