Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Fill Macro II
Below is my earlier question.. My new problem is that the autofill command
doesn't seem to work when the selected area is two-dimensional. For example, if I want to take several adjacent cells in a row and fill them down, the macro crashes. I'm wondering if I should try using a "FillDown" command rather than AutoFill. I think this can definitely be done, but I'm not sure what the parameters of the command would be... Any thoughts? (I'd like to create a macro to do fill right in this case, too.) Thanks! Actually, try this, after selecting the cell to copy, and the area that you want to fill in: Sub FillDownSelection() Selection(1).AutoFill Destination:=Selection, Type:=xlFillValues End Sub HTH, Bernie MS Excel MVP "Mike" wrote in message ... Is there a way to design a macro that can perform the 'fill down without formatting' procedure for cells that I highlight? I've tried to write it but it busts if I select a different number of cells that I used when I recorded it. Thanks for the help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fill Down Macro | Excel Discussion (Misc queries) | |||
Copy or Fill Down Macro? | Excel Discussion (Misc queries) | |||
Macro for Auto Fill | Excel Discussion (Misc queries) | |||
Fill Formula - Macro | Excel Discussion (Misc queries) | |||
Fill formulas down in macro | Excel Discussion (Misc queries) |