counter = 15
Range("C1").Resize(counter,1).Formula = _
"=LEFT(OFFSET($A$27,(ROW($C1)-1)*14,0)," & _
"LEN(OFFSET($A$27,(ROW($C1)-1)*14,0))-8)"
--
Regards,
Tom Ogilvy
Novice wrote in message
...
How do I place a formula in a cell while using a counter? Here's an
example of a formula that I want to use:
LEFT(OFFSET($A$27,(ROW($C1)-1)*14,0),LEN(OFFSET($A$27,(ROW($C1)-1)*14,0))-8
In addition, I want to place the same formula in the same column (as an
example Column C). Therefore, Cell $C1 will change to $C2 and so on.
I want to place the original formula in Cell C1 and then C2... I need
to use a counter to tell the program when to stop.
How do I do this? Thanks.
------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/