VBA to define dynamic macro name using cell value?

Context:

I have a workbook with 15 sheets.
I have a macro for each sheet called "RESET_Sheet1", "RESET_Sheet2", "RESET_Sheet3", etc (each RESET_ macro is unique to the respective sheet so can't just make one generic RESET_ macro for all sheets)
On a hidden sheet I have a named range that lists each sheet name.
I'm trying to finish a simple macro that loops through each sheet in that list and 1) selects the sheet, 2) calls the RESET_SheetX macro.

The macro runs fine except for the part about calculating the macro name for the specific sheet and call it. I tried something like this, but it doesn't work.

Please Login or Register  to view this content.

I've been googling and trying possible solutions, but keep coming up empty so it's time to break out the big guns and ask yall.

Any ideas how to make that work?

Figures; I figured it out minutes after posting the question...

For posterity, here's what I came up with.

Please Login or Register  to view this content.

If you have a better way to do it I'd love to hear/see it.

Originally Posted by TMS

That could probably be just:

Please Login or Register  to view this content.

If you process every sheet, maybe something like:

Please Login or Register  to view this content.

I'll test that out, thanks!

That second bit of code is great too, but unfortunately won't work for this application since I'm not doing every sheet in the workbook (there are more sheets than what's in that list). I'll keep that handy though, I'm sure I'll use it somewhwre eventually.