Selecting cols and doing a formula using variable offsets
 

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

Selecting cols and doing a formula using variable offsets
 

bump bummp


--
McManCSU
------------------------------------------------------------------------
McManCSU's Profile: http://www.excelforum.com/member.php...o&userid=24379
View this thread: http://www.excelforum.com/showthread...hreadid=380165