Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using offset to select a range | Excel Programming | |||
copy an offset value when select | Excel Programming | |||
what does target.offset(0,-1).select mean here? | Excel Programming | |||
Help in using an Offset in a .Range().Select | Excel Programming | |||
Select and Copy Range using Offset | Excel Programming |