Hi
I'm sure someone must have noticed this before but so far I haven't been able to find a solution searching the web (if there is one). I've written a a simulation in VBA and it works on the PC ok. The simulation updates cells on a worksheet as it runs to show how the simulation is proceeding, but NOT on a Mac(Leopard 10.5.1.) with Excel 2004.
A simple subroutine demonstrates what I mean
Sub Test()
Dim i As Integer
For i=1 to 1000
Range("A").value = i
Next i
End sub
On Excel on the PC you see the cell A increasing to 1000 (very fast) as you run the macro, but on the Mac it only seems to update the cell after the macro finishes. This you see the cell go from blank to 1000 (after several seconds!). This really makes the user interface pretty hopeless in my simulation.
I'd be grateful for any help on this
thanks
I'm sure someone must have noticed this before but so far I haven't been able to find a solution searching the web (if there is one). I've written a a simulation in VBA and it works on the PC ok. The simulation updates cells on a worksheet as it runs to show how the simulation is proceeding, but NOT on a Mac(Leopard 10.5.1.) with Excel 2004.
A simple subroutine demonstrates what I mean
Sub Test()
Dim i As Integer
For i=1 to 1000
Range("A").value = i
Next i
End sub
On Excel on the PC you see the cell A increasing to 1000 (very fast) as you run the macro, but on the Mac it only seems to update the cell after the macro finishes. This you see the cell go from blank to 1000 (after several seconds!). This really makes the user interface pretty hopeless in my simulation.
I'd be grateful for any help on this
thanks