I want to put a formula in a selected region of cells which changes
after every pass in a for loop.
This is what works for column G, but I want to have the column change
each pass.
Selection.AutoFill Destination:=Range("G3:G207"),
Type:=xlFillDefault
Something like this is what i need:
Selection.AutoFill Destination:=Cells(3:finalrow, x+offset),
Type:=xlFillDefault
Can I somehow use Range() with numbers for the column? How about doing
it using Rows()?
Thanks!
--
McManCSU
------------------------------------------------------------------------
McManCSU's Profile:
http://www.excelforum.com/member.php...o&userid=24379
View this thread:
http://www.excelforum.com/showthread...hreadid=380165