Hide rows when A4 to A703 is blank and still able to protect rest of the sheet, help

[gandreso]

Hi,
I need some help with a macro. I have a lot of data in column A that can wither be a word or an empty cell. I want to hide the rows that have column A as a blank.
The good thing is that I know the range, and it will always be from A:4 to A:703. But if its possible I would be able to protect the other part of the worksheet so the rows thats not 4-703 wants to be locked and still able to run the macro.
Is that possible?
/gandreso

[berlan]

Hej Gandreso,

You can set the protection using UserInterface to only allow macros to work, e.g.

Please Login or Register  to view this content.

And as for hiding any rows with blank cells within range A4:A703,

Please Login or Register  to view this content.

with error wrapping since Specialcells would return error if no empty cells within usedrange.

Hope this helps.

Hälsningar,
berlan

[gandreso]

That sounds smart! Do I put it before my macro or as one individual?