Autofill Destination range open

  • Thread starter Thread starter J.W. Aldridge
  • Start date Start date
J

J.W. Aldridge

recorded this line in a macro....

Need for this to read as an open range instead of stopping at F784.
Will always start at A2- F2 but last row (F784) may change..


Selection.AutoFill Destination:=Range("A2:F784")
 
To find the last row based on F

iLastRow=Range("F65536").end(xlup).row
Then you substitute in your instruction:
Selection.AutoFill Destination:=Range("A2:F" & iLastRow)
 
You must log in or register to reply here.

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

Selection.AutoFill Destination:=Range 0
Autofil syntax to auto-complete the range 3
Autofill with Column as a variable 5
Autofill Error 4
Flexible autofill in macro 3
autofill down until reach variable range 3
Problem Applying Formula to cell 2
Autofill destination incrementing date by 1...don't want it to 3

Back
Top