Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subscript out of Range | Excel Discussion (Misc queries) | |||
what does 'Subscript Out of range' mean?? | Excel Worksheet Functions | |||
subscript out of range | Excel Programming | |||
subscript out of range | Excel Programming | |||
Subscript out of range | Excel Programming |