Subscript out of range
 

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

Subscript out of range
 

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.

Subscript out of range
 

Greg,
I assume the WB is actually "Backup Exec Check v2.0f.xls" ?

NickHK

"Greg Glynn" wrote in message
ups.com...
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

Subscript out of range
 

Thanks Stopher ... That fixed it.

Brilliant.

Greg


Stopher wrote:
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.