Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error 9 - Subscript out of range
I am using a form for the users to fill in. The values filled in by
user is populated in a sheet when the user clicks submit button . This sheet alone is emailed using the mail system. This code works for all except one user. That user keeps getting Error 9 ( subscript out of range)/ 91 (object variable or with block variable not set) and the debug cursor points to worksheet select code. Workbooks("Form.xls").Sheets("sheet2").Activate 'Delete values in column B if there is any data Columns("B:B").Select Selection.ClearContents Range("B1").Select ActiveCell.Value = txtname.Value Not sure what is wrong. May i request your help. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subscript out of range error | Excel Programming | |||
Runtime Error - Subscript out of range despite On Error statement | Excel Programming | |||
Subscript out of range error - save copy error | Excel Programming | |||
Subscript out of range error - save copy error | Excel Programming | |||
Type Mismatch error & subscript out of range error | Excel Programming |