read excel formula cell only returns 001 ?

[jacktripper]

I have a script which writes to an excel sheet and saves it. Once the cells have values, another column runs calculates on those cells. When I open the sheet afterwards, the formula cells all look correct.

BUT, when I try to use excel to read from those formula cells, all it returns is "001" when using the Cells(x,y).Value command. How can I get the calculated results of the formula and not this useless integer?

 

[SkipVought]

hi,

Are you coding in VB Script or VBA within Excel?

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}

 

[jacktripper]

Ack. Turns out I am an idiot. I've been looking at this for hours and just now noticed that there are lots of hidden columns. So, when referencing the cell I was hitting the wrong one with the number I was using for the col. UGH!

Well, thanks for replying anyway!