VBA

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

Hello all.

I've recorded a macro to delete empty rows on the first worksheet in a workbook containg 10 sheets. However what I want the macro to do is go to the next sheet, perform the macro operation and then move to the next sheet until all are done. Unfortunately i don't know waht code to append to the end of the macro to tell it to do this. CAn anyone help?

Regards

Lee

Tom Schreiner · Apr 11th, 2002, 08:07 AM

No Problemo

Dim ws as Worksheet
For Each ws in WorkSheets
ws.activate
Call Your macro here
Next
Will loop through every worksheet in your workbook.

Tom

LeeHitchen · Apr 11th, 2002, 08:12 AM

Wahey!!

Thanks a bunch TsTom, works a treat.

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

Apr 11th, 2002, 07:30 AM	#1
LeeHitchen New Member Join Date: Mar 2002 Location: England Posts: 26	Hello all. I've recorded a macro to delete empty rows on the first worksheet in a workbook containg 10 sheets. However what I want the macro to do is go to the next sheet, perform the macro operation and then move to the next sheet until all are done. Unfortunately i don't know waht code to append to the end of the macro to tell it to do this. CAn anyone help? Regards Lee

Apr 11th, 2002, 08:07 AM	#2
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	No Problemo Dim ws as Worksheet For Each ws in WorkSheets ws.activate Call Your macro here Next Will loop through every worksheet in your workbook. Tom

Apr 11th, 2002, 08:12 AM	#3
LeeHitchen New Member Join Date: Mar 2002 Location: England Posts: 26	Wahey!! Thanks a bunch TsTom, works a treat.