Macro to Copy and Paste to a Variable Range

pliskers

Active Member
Joined
Sep 26, 2002
Messages
394
Office Version
  1. 2016
Platform
  1. Windows
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?
 

Some videos you may like

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

Datsmart

Well-known Member
Joined
Jun 19, 2003
Messages
7,985
Hi pliskers

Try this:

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

Watch MrExcel Video

Forum statistics

Threads
1,118,530
Messages
5,572,680
Members
412,481
Latest member
nhantam
Top