problem with spreadsheet number format loaded from array
 

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