gravanoc
Active Member
- Joined
- Oct 20, 2015
- Messages
- 348
- Office Version
- 365
- Platform
- Windows
- Mobile
For an unknown reason the area I copied and pasted to a new sheet has a cells that appear blank but are flagged as having data. The sheet I copied from was protected, which might have some bearing on this, I guess. I've experienced this issue before, and would like to know if there is a process to quickly turn those fake blanks into real blanks. This is because I'd like to use the Goto Special command to select the constants in that range, but they are currently flagging the fake blanks as constants. It's a large area, so simply selecting selecting all the cells and clearing them is tedious.