I have a situation where I reference a Profile sheet in a workbook that remains open.
I'd like to create a reference to that sheet that I can use throughout the code module. For example, instead of
SSOD.Range("Author").Value = Workbooks("FEC_Mstr.xls").Worksheets("Profile").Range("User").Value
I'd like to use something like
SSOD.Range("Author").Value = Profile.Range("User").Value
I'd rather do this with some kind of Function (or something else) and avoid the Global Variable thing, however I'm not sure how to code it.
Any help would be appreciated.