An alternative heading may be comments within a cell.
I often like to "play" with large spreadsheets by quickly changing a few numbers here and there and observing the results of the calculations. Is there an equivalent to the ' (single quote) in VBA which tells Excel to ignore everything after the ' ? I want to do this WITHIN the Excel cell (not Insert a Comment).
I'd like to be able to quickly edit a cell to add a new number but at the same time keeping the original number (as a comment which Excel ignores) in case I need to revert back later.
Penfold
I often like to "play" with large spreadsheets by quickly changing a few numbers here and there and observing the results of the calculations. Is there an equivalent to the ' (single quote) in VBA which tells Excel to ignore everything after the ' ? I want to do this WITHIN the Excel cell (not Insert a Comment).
I'd like to be able to quickly edit a cell to add a new number but at the same time keeping the original number (as a comment which Excel ignores) in case I need to revert back later.
Penfold