Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
let me clarify....
across to AT only and then down as far as B goes. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |