Thread: Replace Loop
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Darrell[_4_] Darrell[_4_] is offline
external usenet poster
 
Posts: 2
Default Replace Loop

I am looking for helping in creating a loop that will
replace part of a formula in selected cells with the next
sequential number.
Ie. If the cell formula is =B4 then replace it with B5.
The selection will have a variety of columns, but the row
will always be the same.
I then want to print and do the replace again for the
next row of data.

Thank you for your assistance.

Darrell