I have a workbook with about 50 sheets in it. All have the same format and layout. Each have a button and in field A1 of each sheet is where the below needs to reference. When I started building this i had created a code for each sheet individiually and now have 50 which is causing my workbook to act up. How can I change the code to be just "Current Sheet"A1 & A9 and then assign the 1 code to each sheets button. So for instance the below where it has sheet44 would just need to be current sheet Sheet 3 will always be the same. Any help on this would be much appreciated!!
Bookmarks