I’m learning macros as I go, so I hope there is an obvious solution here. Google and Youtube doesn’t seem to help much!
I refer to a specific cell to be changed in a variety of functions, based on the users needs. Inside of each individual function, I have been using ‘Dim’ and ‘Set’ i.e.:
Dim foodtype As Range
Set foodtype = Worksheets("Sheet1").Range("A1")
Is there a way that I can just establish the variable once and use it in individual functions?