It's been about 7 years since I've used this forum so please forgive any lapse in decorum.
I have a worksheet with 50+ variables. In each cell of one of the columns, I have a drop-down list with 30+ selections to choose from. Each of those selections has a macro attached to it. Each macro, when run, can change from 1 to 10 of the variables in the worksheet. Each macro will change its assigned variables, then copy a selection from the row above it, paste it into the current row replacing any changed variables with the new variable values.
This is my question: each macro I build has to have all 50+ variables defined in the individual macro. Given that I have to build 30+ macros this seems like a lot of overhead. Is there a way to make the 50+ variables global so that each individual macro only has to define the variables it will be changing?
Bookmarks