Clear Cells Not Clear

[prjt]

Hi all,

I am using .Clear to clear some cell values and while it appears to be working for the most part I am having a real problem with a common occurrence in my excel; I was wondering if anyone could help.

To be more specific, my VBA is working fine (which is why I did not attach) and the contents (and formatting) of my cells are cleared when I check them, HOWEVER when I use Ctrl+Up or Down Excel is still going to the last cell of where the data was before it was cleared (This is my problem because I am using .End elsewhere and it is also going to the cell where data USED to be).

When I highlight the range and actually press delete this issue no longer occurs (both manually doing Ctrl +Up/Down and when I run the VBA with .End).

This is also a problem when I manually delete rows or cells (excel still selects cells/rows that used to contain data).

I am all out of ideas so any help would figuring out why this is happening and how to fix it would be great.


Thanks

[skywriter]

Maybe someone knows exactly what the cause is by just your description, but I would need an example sheet and instructions on exactly what you do to recreate the problem.

ViewPic

[prjt]

RESOLVED MYSELF

Annnddd...I feel dumb....


Edited the wrong VBA....

[skywriter]

You have code where you say = "" and that is the issue.

Please Login or Register  to view this content.

[prjt]

Haha yeah I noticed that I was editing code in Module 3 and not on the button. So I kept thinking I was using Cells().Clear, when it was actually still only using "".

Sorry to have wasted time, but thanks for the help.

[skywriter]

You didn't waste my time you just added to my knowledge base.

Haha yeah I noticed that I was editing code in Module 3 and not on the button. So I kept thinking I was using Cells().Clear, when it was actually still only using "".

Sorry to have wasted time, but thanks for the help.