| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofill dynamic no. of rows and columns
Hi,
I'm trying to copy the formulas from the first row starting from B2 to some finite column number and applying these formulas (which may be different) to a dynamic number of rows. In other words, the "BK6" is not a fixed value. How can I achieve this? Thanks! Range("B2").Select Range(Selection, Selection.End(xlToRight)).Select Selection.AutoFill Destination:=Range("B2:BK6"), _Type:=xlFillDefault |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Autofill counting up Columns and Rows! | Excel Worksheet Functions | |||
| Autofill Macro for 2 rows and 100 columns | Excel Programming | |||
| Autofill Macro for 2 rows and 100 columns | Excel Programming | |||
| autofill information from rows to columns without using transpose | Excel Discussion (Misc queries) | |||
| Autofill formula to last row with data when rows will be dynamic | Excel Programming | |||
Threaded Mode
