I'm going mad. I've tried so many different ways. I've even had it
work, save the project, come back 30 min. later, and then doesn't work.

No changes made.


All I'm trying to do is Select a cell from another sheet.


I'd prefer to select the sheet using: Sheet12 ; rather than it's name:
Loads & I have to use Cells()


Tried these and more...
Worksheets("Loads").Cells(8, 41).Select
Sheet12.Cells(8, 41).Select


"Select Method of Range Class Failed" - error
I assume that has something to do with the '.select'