Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am currently using the following macro in many of my worksheets and love
the time it saves. It's for one column. My question is, can this be modified to do 2 or more columns? Dim endRow As Long endRow = Cells(Rows.Count, 1).End(xlUp).Row Range("A2").AutoFill Destination:=Range("A2:A" & endRow) I have formulas in A2 and B2 and want to autofill at the same time instead of separately. I tried modifying (Range("A2:B2"),etc.) but can't get it to work. Any help would be greatly appreciated! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro to add Multiple columns | Excel Discussion (Misc queries) | |||
Convert macro that runs against entire column to run in current row | Excel Programming | |||
Macro to select multiple columns | Excel Programming | |||
Sum Multiple Columns with Macro | Excel Programming | |||
macro that loops to multiple columns | Excel Programming |