Deleting Rows

[LeeHitchen]

Hi all

Bit of a problem i hope someone cn help with.

I want to deleted all rows within a workbook (multi sheets) where column j has no values.

I'm able to do each sheet one by one by Selecting column j then Edit/GoTo/Special/Blanks followed by Edit/Delete/Entire Row. However, I'm sure it would be possible to do all sheets in one hit maybe by using a macro?

Ta

Lee

 

[Anne Troy]

Record the macro. I plan to have the instructions for recording in Excel soon, but they're very similar to these instructions for recording in Word. The difference is that with Excel, you assign a toolbar button AFTER you create the macro.

Go here:

http://www.thewordexpert.com/wordvba.htm#HowToRecordAMacro

 

[LeeHitchen]

Thanks for that. I've recorded the macro against the 1st sheet in my workbook. Could you please tell me what code I have to append to the end of the macro to force Excel to move on to the next sheet, and the next etc until it completes the last one. Apolgies for sounding so naive!

Regards

Lee