Special Cells Delete Shift up not consistent

The attached WkBook has two sheets. The macro successfully deletes cells, and shifts up, on the range A1:C10 in Sheet 2, but not on the range B2:AL13 in Sheet1. I can't figure out what the problem is.

Can someone tell me if there is a reason for the range in Sheet 2 not to be changed by the macros?

Thank you

Here's the code

Please Login or Register  to view this content.

Thank you for the excellent responses. Fairly new to vba and I enjoy this website.

Hi BHudPE

I ran your code on Sheet2 and it moved all the numbers up (for the selected range) just like it should.
Then I tried it on Sheet1 and you are correct - the letters didn't move up.

THEN I selected all the blank cells on sheet1 and did a Clear Contents on them. Then it worked. It looks like the blank-looking cells on Sheet1 are not blank. I believe this is your problem.

Write a little code - or in the immediate window try to have it give you back what type of cells they are. I'd bet they aren't xlCellTypeBlanks!

I hope that helps. I'm always fooled by blank characters that aren't spaces.

hi,

I don't think I have the answer but I have some suggestions for your code.

Please Login or Register  to view this content.

hth
Rob

Try this first, once it has run it will run your code

Please Login or Register  to view this content.