-> Christian Moe writes: > Hi, Dude,
> Not quite sure why that doesn't work (nor gives an error message about > trying to set the same cell). However, it will work if you specify the > cell range: >> @4$4=$sdate + $3::$4=@-1$4+$3 > ^^ > @4$4=$sdate + $3::@5$4..@20$4=@-1$4+$3 > ^^^^^^^^^^^ Yep, that works perfectly. The only drawback is when I have to add a new row etc. but I can live with that. Thanks! > BTW, it's OK to omit the reference to the same column, so you can save > two characters: > @4$4=$sdate + $3::@5$4..@20$4=@-1$4+$3 > ^^ > @4$4=$sdate + $3::@5$4..@20$4=@-1+$3 Got it. > Yours, > Christian cheers -- -dude Too brief? Here's why! http://emailcharter.org