LeeHitchen
New Member
- Joined
- Mar 20, 2002
- Messages
- 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
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