Date recalculation

[solidgumby]

I work to build an excel sheet that calculate certain values at certian
time. each month, it needs to recalculate the date column. all the
cells column refer to one cell that contain "=TODAY()". I use the
following macro:

Sheets("first sheet").Select
Range("A4").Select
ActiveCell.FormulaR1C1 = "=TODAY()"

Sheets("second sheet").Select
Range("A4").Calculate
Range("A7:A37").Calculate

the first sheet is refreshing correctly but not the second one.
How do i do to refresh the values of A7 to A37 (wich refer to first
sheet (A4) that is correctly refreshed)

thanks

sg

 

[Dave Peterson]

Is there a reason you don't use:

application.calculate

??

 

[solidgumby]

i need to recalculate only the given range... because it rely on
another slow system
but i ve found out the error, it was a logic error
thanks anyway

sg