ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   fill down and across range (https://www.excelbanter.com/excel-programming/439829-fill-down-across-range.html)

J.W. Aldridge

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

J.W. Aldridge

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