Autofill help

  • Thread starter Thread starter Patrick Simonds
  • Start date Start date
P

Patrick Simonds

I need a piece of code which will go to the last cell (with data) in column
A and then AutoFill down one cell.
 
Patrick Simonds,
range("A" & rows.Count).End(xlUp).EntireRow.AutoFill _
destination:=range("A"&rows.Count).End(xlUp).EntireRow.Resize(2)
to autofill columnA only remove ".EntireRow"
Cecil
 
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

Autofill Help Please 1
Autofill not working. 3
autofill without a destination range 7
Copy formula down 2
Autofill macro - variable destination cells 7
Autofill destination incrementing date by 1...don't want it to 3
PLEASE HELP WITH AN SPECIAL AUTOFILL 3
Autofill with Column as a variable 5

Back
Top