fill down and across range

  • Follow


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
0
Reply J 2/22/2010 6:47:48 PM

let me clarify....

across to AT only and then down as far as B goes.
0
Reply J 2/22/2010 7:30:59 PM

1 Replies
332 Views

(page loaded in 0.214 seconds)

Similiar Articles:
















7/25/2012 3:36:54 AM


Reply: