Offset & Select
I am trying to select a dynamic range and fill the formatting right four
columns. The code that I have come up with is shown below:
Selection.AutoFill Destination:=Range("T6:T" & lastRow).ActiveCell.Offset(0,
4).Select, Type:=xlFillFormats
This is part of a larger loop, which works fine when this line removed.
It is probably just a period or something; just can't figure it out.
Thanks in advance,
Ryan----
--
RyGuy
|