Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
cannot autofill 2 cells info at the same time
Hi,
i try to autofill 2 cells(Rw 3 & 4 info at the same time,and wish to auotfill rw 5 till lastrow of used rows. i try to do manual , it can be autofill, but when macro, it can't. The target is to get the final result like that: Column C * Autofill Col C only H 'Row 3 D "Row 4 H ' And so on... D H D H D H D H D H D H D H 'Last Used Row this is my script: Sheets("New Forecast").Select Range("C3").Select ActiveCell.FormulaR1C1 = "H" Range("C4").Select ActiveCell.FormulaR1C1 = "D" Range("C3:C4").Select Selection.Copy Range("C5").Select Selection.AutoFill Destination:=Range("C5:C" & ActiveSheet.UsedRange.Rows.Count) can someone advise me? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Move cell info and info in range of cells on new entry | Excel Discussion (Misc queries) | |||
Copy info into empty cells below info, until finds cell with new d | Excel Discussion (Misc queries) | |||
Link info in one cell to info in several cells in another column (like a database) | Excel Discussion (Misc queries) | |||
Formula to Autofill Info based on Other Data | Excel Discussion (Misc queries) | |||
Autofill: Need to autofill one week block, (5) weekday only into cells. | Excel Discussion (Misc queries) |