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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
cannot autofill 2 cells info at the same time
Hi there
this code is pretty much straight from the excel help file Dim SourceRange As Range Dim FillRange As Range With Sheets(1) Set SourceRange = .Range("C3:C4") Set FillRange = .Range("C3:C32") SourceRange.AutoFill Destination:=FillRange End With Hope this helps steve |
Reply |
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) |