Greg Glynn wrote:
Can anyone tell me why this gets a "Subscript out of Range" error?

MsgBox Workbooks("Backup Exec Check
v2.0f").Sheets("BackupEXEC").Range(Cells(22, 1)).Value

The workbook and sheet DO exist.

(It's driving me insane.)

Regards

Greg

either take out the range or cell and make it one or the other. I would
guess range seeing you have a cell reference in there.