Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fill emply column with formula
I have entered a formula into M2. Now I want to fill it to the last column
which has data in it. When I double-click on the fill handle, I get what I want. However, when I record the action as a macro, I get: Selection.AutoFill Destination:=Range("M2:M3085") I don't want the range hard-coded, because the next time I use the macro the number of rows will be different. When I change the range to M2...end(xldown), I get M2:M65536. How do I specify a range which has the same effect as double-clicking on the fill handle? -- Thanks, Fred Please reply to newsgroup, not e-mail |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Fill formula from a column to row | Excel Discussion (Misc queries) | |||
fill column with formula | Excel Worksheet Functions | |||
Fill Formula Not Adjusting Down the Column | Excel Discussion (Misc queries) | |||
Fill a column with a formula | Excel Discussion (Misc queries) | |||
I want Excel to regard emply cells as zero and display it | Excel Discussion (Misc queries) |