writing a loop to parse multiple sheets.

Hello,

i'm looking for help writing a loop that will perform the same action on 11 worksheets but stop if it gets to a sheet with no data in cell A1. The data in A1 will be text. The code I wrote below below does what I want it to, but I have to run it on each individual sheet. Any help would be greatly appreciated.

~Donny

Please Login or Register  to view this content.

Thanks for the help, but this doesn't work.

Any other ideas?

~Donny

Donny

Try this.

Please Login or Register  to view this content.

I think this will work, but I think I need to tell it what range of worksheets to parse as I don't want it to parse every worksheet in the workbook. Sorry, I should have been more clear in my description.


~Donny

Hi, Donny. Will you need to list each worksheet? Or how exactly do you determine on which sheets this procedure will run?

Jason

This routine will loop through the sheets of a workbook and, depending on the contents of A1 of that sheet, either:
Parse the sheet,
Skip that sheet and go to the next, or
Stop parsing and exit the routine.

Please Login or Register  to view this content.

Jason,

I suppose I would need to list each worksheet by name so that only specific sheets were processed.

Mike,

Thanks, i will try this out as well.

~Donny

Donny

It should be easy to adapt the code I posted.

Can you give more details on which sheets you do want to parse and which you don't?

For instance if I had 15 sheets in the workbook but only wanted to parse sheet 3 though sheet 14.

~Donny

Donny

But how exactly would you determine that?

Would it be based on sheet name?

Sheet position?

Sheet name

And those sheet names would be?

The names of the sheets can change and sheetes can be added/removed over time, so I think I need something where I could modify the names of the sheets as needed, I 'm just not sure how to do this.

Possibly if you could give me an example using sheet2, sheet 3, sheet 4, to sheet 12. The sheets would always be consecutive but not always starting with sheet 1 or ending with the last sheet.

Something like this perhaps.

Please Login or Register  to view this content.

Another option would be to create a userform with a listbox and command button. The listbox could be populated with all sheet names, and you could select the sheets to which you would like to apply the procedure.

You could use code similar to this for the userform:

Please Login or Register  to view this content.

HTH

Jason

I'll try this as soon as I get chance and let you know.

Thanks so much,

~Donny

Norie,

Thanks so much for your help, this works perfectly. Thanks to everyone else as well, this is a really great forum.

~Donny

(I'm learning.....slowly)