You can't select cells on a sheet that is not the active sheet.
You have to select the sheet first, then the cells. E.g.,

Worksheets("Loads").Select
Cells(8,14).Select

Of course, it is rarely necessary to use Select in the first
place, so if you post what you are ultimately trying to do,
someone may have an idea how to accomplish it without having to
select a range.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Kevin O'Neill" wrote in message
ups.com...
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'