• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Error Message When Typing Text Into a Blank Cell

evanlamarr88

New Member
Hello,

I have an error message that I don't know why I'm getting. The message also doesn't give many explicit clues into why I'm getting it. See below:

upload_2017-2-27_17-1-16.png

Can anyone help me? I haven't used the worksheet in a long time, and, as far as I'm aware, I didn't do anything to make this happen.
 
This means it thinks there are data/formulae/formatting in cells either at the very bottom of the sheet of the hard right edge AND, for some reason it thinks you're inserting a cell and trying to move cells below down, or cells to the right, right; do you have any macro code in the workbook at all?
 
No macros, but I did have some formatting (cell borders) that I had applied to blank cells on a couple columns. Once I removed the formatting, the error msg went away. It was funny; I just hadn't seen it before. It's weird that formatting would do that.
 
Back
Top