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?

Terry

sure, reference it like this

Miles = Worksheets("Monday").Range("EndMiles").value

Thanks much!!!