confusion123
Active Member
- Joined
- Jul 27, 2014
- Messages
- 400
My code below performs a calculation correctly but if the user changes the name of the worksheet, it will fail.
I want to make it specific to the codename of the worksheet, the codename for Apples is wksApples
How can I change it?
Thanks
Code:
Cells(2, 2).FormulaR1C1 = "=MAX(Apples!C,Oranges!RC[-1])"
I want to make it specific to the codename of the worksheet, the codename for Apples is wksApples
How can I change it?
Thanks