Deleting Rows

LeeHitchen · Apr 11th, 2002, 06:42 AM

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 · Apr 11th, 2002, 06:45 AM

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...ToRecordAMacro

LeeHitchen · Apr 11th, 2002, 07:04 AM

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

Apr 11th, 2002, 06:45 AM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	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...ToRecordAMacro __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 11th, 2002, 06:42 AM	#1
LeeHitchen New Member Join Date: Mar 2002 Location: England Posts: 26	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

Apr 11th, 2002, 07:04 AM	#3
LeeHitchen New Member Join Date: Mar 2002 Location: England Posts: 26	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