Object Required - No Set

[MICowboy13]

Hi,

Can someone help me with a Object Required error? Please see the following code. I get an error on the "For Each Mach in Mach" line. I believe this has something to do with "Mach" not being set, but I have no idea how to do so.

Please Login or Register  to view this content.

Thanks

[Norie]

The values in the array are strings, not worksheets.

You could try declaring Mach as Variant, or perhaps even string.

Mind you, to me anyway it's not clear what you want to do so that might not achieve the required result.

[MICowboy13]

Norie,

Thanks for the tip. It works but only to a certain extent, the macro stops after adding 1 sheet when it should add more. Maybe if I explained what I am trying to do you could give me a few more tips? I am not proficient in VBA so I could be way off track with the current code.

All I am trying to do is search the sheets with the names in the array of my original post and check cell O236 for a number greater than 0. If true I would like to add a new sheet and name it with the sheet it copied and "Budgets" (ex. Mach-1 Budgets). If false do nothing.

Thank You

[Norie]

Do you want to check O236 in each of the sheets you've named in the array?

[MICowboy13]

Yes, my apologies for not making that clear.