-> 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


Reply via email to