<div>
Hello,<br />
<br />
can you post the code you are using and/or the workbook? Maybe there is a leading space before the = sign?<br />
<br />
cheers, teylyn
</div>


<div>
Thank you! &nbsp;I should have known that!
</div>


<div>
<div class="content wysiwyg-content">
I'm writing a simple macro to check formulas and make sure they're correct on multiple spreadsheets in a given workbook; however, I noticed in one section of the spreadsheets there are formulas that pick up info from the Wednesday schedule. &nbsp;If that cell on Wednesday schedule is blank then the cell on the other spreadsheets are blank otherwise the content of the Wednesday cell shows, as they should. &nbsp;However, if I have the macro put the formula into the cell or if I manually write the formula into the cell it shows the formula rather than reading the Wednesday schedule. &nbsp;It is not formatted to show formulas and if I copy a pre-existing formula and paste it into the cell that shows the formula I wrote, the formula disappears, as it should, on the spreadsheet and can only be seen in the formula bar. &nbsp;I have no idea how or why this happens.
</div>
</div>


I'm writing a simple macro to check formulas and make sure they're correct on multiple spreadsheets in a given workbook; however, I noticed in one section of the spreadsheets there are formulas that pick up info from the Wednesday schedule.  If that cell on Wednesday schedule is blank then the cell on the other spreadsheets are blank otherwise the content of the Wednesday cell shows, as they should.  However, if I have the macro put the formula into the cell or if I manually write the formula into the cell it shows the formula rather than reading the Wednesday schedule.  It is not formatted to show formulas and if I copy a pre-existing formula and paste it into the cell that shows the formula I wrote, the formula disappears, as it should, on the spreadsheet and can only be seen in the formula bar.  I have no idea how or why this happens.

Hello,

can you post the code you are using and/or the workbook? Maybe there is a leading space before the = sign?

cheers, teylyn

Excel formula, IF statement, shows on spreadsheet and shouldn&#39;t

I&#39;m writing a simple macro to check formulas and make sure they&#39;re correct on multiple spreadsheets in a given workbook; however, I noticed in one section of the spreadsheets there are formulas that pick up info from the Wednesday schedule.  If that cell on Wednesday schedule is blank then the cell on the other spreadsheets are blank otherwise the content of the Wednesday cell shows, as they should.  However, if I have the macro put the formula into the cell or if I manually write the formula into the cell it shows the formula rather than reading the Wednesday schedule.  It is not formatted to show formulas and if I copy a pre-existing formula and paste it into the cell that shows the formula I wrote, the formula disappears, as it should, on the spreadsheet and can only be seen in the formula bar.  I have no idea how or why this happens.

Excel formula, IF statement, shows on spreadsheet and shouldn't

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.