marcus
12/14/2006 9:32:00 PM
Hi Chris
It sounds like your calculation has been set to Manual. If you go
Tools - Options - Calculations and check the Automatic option this
should solve your problem.
Regards
Marcus
Chris wrote:
> Hi,
>
> I have loaded a worksheet using a standard 2 dimensional array.
> This is fine.
>
> I then change the columns into number format.
> Columns("H:S").Select
> Selection.NumberFormat = "0.00"
> Range("I18").Select
>
> The problem is that the new cell format does not take affect until I double
> click into a cell. The cell is not computable until I do this. If I try to
> sum columns or rows it only sums the cells that have been double clicked into.
>
> Is there a way in code I can fix this without writing a nested loop to go into
> every cell to activate?
>
> thanks
>
> Chris