| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Runtime error 13-- Setting a variant Range?!
Why doesn't this work?
Dim MyRange as Variant Set MyRange = ("C" &(Me.txtItem_Number.Value) & ":G" &((Me.txtItem_Number.Value)+ 2)) Range(MyRange).ClearContents I also tried Dim MyRange as Range. How can I work around this when I need to clear a different area every time the macro runs? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| runtime error 9 subscript out of range | Excel Worksheet Functions | |||
| Runtime Error '9' Subscript out of range HELP | Excel Programming | |||
| Runtime Error - Subscript out of range despite On Error statement | Excel Programming | |||
| Getting Excel Runtime Error 9: Subscript out of range | Excel Programming | |||
| Runtime error 91 when assigning range | Excel Programming | |||
Threaded Mode
