Excel formula, IF statement, shows on spreadsheet and shouldn't
Posted on 2011-03-08
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.