Set active sheet by name

Mar 17, 2009 at 5:12 PM

Hi there,

Is it possible to call a sheet by its name rather than its index?

So normally I would use


but what I want to do is to call the sheet by name eg


but this does not work... any ideas?


Mar 17, 2009 at 5:27 PM
This should do the trick for now:


Mar 17, 2009 at 5:36 PM

genious, gald i asked as I would never have figured that out