trouble shoot Selection.AutoFill Destination
 

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.

trouble shoot Selection.AutoFill Destination
 

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.


---
Regards.
Norman

"mario" wrote in message
...
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.