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 |
fill down and across range
let me clarify....
across to AT only and then down as far as B goes. |
All times are GMT +1. The time now is 09:28 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com