Remove blank rows

Hi

I do not know how to use macro. I am tired to delete the blank rows manually each month.

Please make my days easier if you know how I can go about remove the blank rows on the attached file. I have used F5 but it is not friendly

If I have to use macro - can you give me the baby step-by-step and the codes pls

Thank you all!

Please post in the correct forum in the future. I will move it for you this time.

Please have a look at our forum rules.

Am so sorry.. I have never used macros before.. how do I go about using the code you provided?

can I email you the file to help?

I have placed the macro in your sample file. It is named Macro1

Here are instructions for running it:

http://spreadsheets.about.com/od/adv...el_macro_5.htm

You're welcome. I did it because your green light was out.

I would replace

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

Also, add Application.ScreenUpdating = False at the beginning of the code and Application.ScreenUpdating = True at the end.

The code would look like this

Please Login or Register  to view this content.

Not nitpicking, just observing.

John

Might be that "lazy" is the wrong word.
You could be busy and I have time on hand.

Hi

Thank you for all the help. I am still stuck

I do get the following error message

RUN-TIME ERROR '1004'
AUTOFILTER METHOD OF RANGE CLASS FAILED

Can I email the file am working on to someone who can help.. please

no its is not protected

I am about to give up... i try to attach the whole file but the MB on myfile wont allow me

if one can help pls.. let me email u

JohnsonBeGood.
Did you get it working?
If so, what was your solution? I'm always learning and would like to know how the problem was solved.
Thanks and Regards
John

Sorry.. I was running close to the deadline so I had to email our IT dept to assist and give me the completed file.

I am not sure what they did. Thanks