$$Excel-Macros$$ Re: cell reference across worksheets sometimes works, sometimes does not

never mind. I figured it out myself. The referenced cells were formatted as text (Rightclick > Format Cells > Text). So, when the those cells were dereferenced, the referencing cell's format was also changed to "Text". But when a cell formatting is set to "Text", the reference no longer works...

$$Excel-Macros$$ cell reference across worksheets sometimes works, sometimes does not

Hi there, I have a strange problem in Excel 2003 SP3: when writing a reference to a cell on another worksheet like SheetName!C98 or SheetName!$C$98 sometimes Excel does not display the referenced cell's value but instead displays the reference formula SheetName!C98. If I copy a working referencin