trouble shoot Selection.AutoFill Destination

  • Thread starter Thread starter mario
  • Start date Start date
M

mario

Can somebody correct this code:
Selection.AutoFill Destination:=Range(Cells(1, 4).Address, Cells(LastRow,
3).Address)

The above one gives a lot of errors.
 
Hi Mario,

Your range syntax could be simplified to:


Selection.AutoFill Destination:=Range(Cells(1, 4), _
Cells(Lastrow, 3))

However, as you have not indicated the
problems which you have encountered
and you have not provided any details
of your objective, it is difficult to help
you further.
 
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
macro to copy rows that contain a cell with a certain number 2
Type Mismatch Error 8
help with macro vba 4
Autofill with Column as a variable 5
Coding problem 2
DECLARE VARIABLES PROBLEM 7
Defining destination Range 5

Back
Top