Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do i trouble shoot an IF function | Excel Worksheet Functions | |||
Macro code to dll and vba code trouble shoot. | Excel Programming | |||
Selection.Autofill Destination:=Range(ActiveCell.Value) | Excel Programming | |||
trouble shoot pointing to a cell | Excel Worksheet Functions |