Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
fill down and across range
Set rngFormula = .Range("ag2")
Need to fill range across as well as down. Tried changing the range from ("ag2:at2") but didn't work. Entire code portion as follows: With ThisWorkbook.Worksheets("ERRORs") Set rngData = .Range("b2:b" & .Cells(.Rows.Count, "b").End(xlUp).Row) Set rngFormula = .Range("ag2") rngFormula.aUTOFILL _ Destination:=.Range(rngFormula, _ .Cells(rngData.Rows(rngData.Rows.Count).Row, rngFormula.Column)) End With |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
fill down and across range
let me clarify....
across to AT only and then down as far as B goes. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fill range | Excel Programming | |||
SumIf - when I fill down the Range, Criteria & sum range changes | Excel Worksheet Functions | |||
How to fill a range with data from another range? | Excel Discussion (Misc queries) | |||
Range doesn't fill | Excel Programming | |||
Fill down range | Excel Programming |