Delete rows failing

[jomili]

On the attached worksheet, in column AH, I'm trying to delete everything below the used range. However, my macro for doing this (change now to select instead of delete) isn't working, because SOMETHING is below the used range. Here's the macro I'm using to select the row below the used range:

Please Login or Register  to view this content.

I think my problem may be non-printing characters, so I've been trying use the following macro to clean them, but to no effect:

Please Login or Register  to view this content.

Any help I can get on this is greatly appreciated.

[JieJenn]

Your "usedrange" is A1:AL 1007 and all the blank cells after AH69 are null values, meaning they cell is not blank. If you just highlight the null cells and hit delete that should fix the problem

[JieJenn]

Clean the blank cells and try this code

Please Login or Register  to view this content.

[jomili]

Jie Jenn,

I guess maybe I didn't explain myself well enough. You're right that "all the blank cells after AH69 are null values"; that's what I want to delete, via macro. But this isn't just a one-time thing; I have 15 workbooks to do this to every day, as a tiny part of much larger operation. The option to "just highlight the null cells and hit delete" would be what I want to automate. How do we do that?

[JieJenn]

I revised the code

Please Login or Register  to view this content.