Macro to remove lines in Data set if Column A value is blank

Hello All,

I have a large set of data that is extracted out of a very old piece of software in Excel format. The layout is pretty rubbish and it is riddled with blank values.

What I want to achieve is a very quick Macro to simply run down the list of data and remove the whole line if the value in Column A is blank.

I have attached a before and after version of Excel to see what I want to achieve. The normal extract will normally contain between 1500 - 2500 lines of data, hence why a Macro would really make my life easier.

Thanks for your help.

Regards

Try this:

Please Login or Register  to view this content.

Hi Sintek,

Not sure if you looked at the sample file however a couple of reason why your code won't do what is needed in this instance.

The "Blank" cells in column A actually contain spaces (either 10 or 1) so they are not technically blank cells.

The lastrow in Column A is not the last row of data which may need to be deleted, rather this is in Column D.

Sintek & PFDave - both work a treat.

Thanks for your help.

Originally Posted by sintek

@ PFDave

Nice catch...Did not even notice that....Thanks

That's ok, seems from the above comment that it worked anyway :/

I only mentioned it to explain why it may not work in this example, but there's some bits in their I didn't know about that I'll use