Forum Discussion
No Cells Were Found
When trying to clear data out of cells in Excel that are using formulas, I select the cells and and use the ‘Go to special’, ‘constants’ option. I receive the following error/message: “No Cells Were...
In that case your original plan of using the Go To command with Constants should work just fine, provided of course that prior to running that command you ensure that the selected range within the worksheet does not include any of the constants that you wish to keep (title, column names, etc.).
Regards
Regards
Yea… that’s what I thought. Example: I have several rows in a column that have a variation of the equation “=SUM(H6-B6)” that all currently have values in the cells. I highlighted just those cells and went to the ‘Go to special’, ‘constants’ option… and hoping to simply click on delete… but instead received the “No Cells Were Found” message. Very strange.