AutoFill down X number of rows.

P

Paul987

Hello. I am trying to autofill a formula down a certain number of rows.
The number is located in cell L4. I can't seem to figure out the
syntax for this. This is what I have, but it does not work.

Selection.AutoFill Destination:=Range("A1:A" + Cells(4, 12)),
Type:=xlFillDefault

Any Help would be great. TIA
Paul
 
J

JE McGimpsey

One way:


With Selection
.AutoFill Destination:=.Resize(Cells(4, 12).Value, 1), _
Type:=xlFillDefault
End With
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autofill & On Error Resume Next 2
Autofill in macro 5
AutoFill Macro Issue 1
Macro - Using a variable number of columns in a Range 2
Loop and autofill 1
Selection.AutoFill Destination:=Range 0
Autofill column values in formulas 4
Autofill block of cells with drop down 1

Top