View Single Post
  #5   Report Post  
Roger Govier
 
Posts: n/a
Default Modifying Cell Addresses and operating on them

Hi

Then maybe
=H14+INDIRECT("I"&ROW(H15)-LT)

Regards

Roger Govier


RPG_Gamer wrote:
The Formula you gave did the trick BUT, the ("I"&15-LT) part stays the
same and does not change for the new cell when the formula is copied.
How do I get round this new problem?