Referencing Workbook Named Ranges in VBA
Is it possible to reference Named Ranges/Cells in a workbook when in VBA? For instance:
On worksheet "Monday", I have a cell named EndMiles located at ROW 16, COLUMN 3. In a called VBA sub, I reference that cell by Miles = Worksheets("Monday").Cells(16, 3).Value. I prefer not to use absolute references since any changes to the sheet could invalidate the functionality of the sub. Help?