| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Why is this an error?
Doug Glancy wrote: davegb, Change "Error" to "Err" and I belive it will work. hth, Doug Thanks, Doug! "davegb" wrote in message oups.com... The following code I copied from a book. But I always get the error message when I select the data range in the refedit control and click OK. Why is it never correct? Private Sub OKButton_Click() On Error Resume Next Set rColHdr = Range(reDataStrt.Text) If Error < 0 Then MsgBox "Invalid range selection, please select the starting range again." On Error GoTo 0 Exit Sub End If uf1021Mid.Hide End Sub Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting instances of found text (Excel error? Or user error?) | Excel Worksheet Functions | |||
| Error Handling - On Error GoTo doesn't trap error successfully | Excel Programming | |||
| Form Err.Raise error not trapped by entry procedure error handler | Excel Programming | |||
| Automation Error, Unknown Error. Error value - 440 | Excel Programming | |||
Threaded Mode
