bananatang
04-12-2011, 04:58 AM
Hi,
Need abit of help please.
I am trying to write and if statement that will trigger a particular macro based on the active worksheets Index Name, as i need ensure the macro will work regardless if the user changes the worksheet name.
Any assistance will be greatly appreciated. I have tried loads of variables but still stuck on this.
Thanks
BT
Need abit of help please.
I am trying to write and if statement that will trigger a particular macro based on the active worksheets Index Name, as i need ensure the macro will work regardless if the user changes the worksheet name.
Any assistance will be greatly appreciated. I have tried loads of variables but still stuck on this.
Thanks
BT