| Home |
| Search |
| Today's Posts |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help passing Range to Class Module method
Simply using Selection is fine. The problem was parentheses around the
argument. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ wrote in message ... oops, can't set to Selection directly. This should work: Set myrange = Range(Selection.Address) regards Paul On Feb 12, 3:38 pm, Brian Herbert Withun wrote: Try Activesheet.Selection regards Paul trying: Set MyRng = ActiveSheet.Selection causes: Runtime-error '438': Object doesn't support this property or method |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select method of Range class failed | Excel Programming | |||
| Select method of range class failed | Excel Programming | |||
| What did I do? (Select Method of Range Class Failed ) | Excel Programming | |||
| Delete method of Range class failed - HELP!!! | Excel Programming | |||
| Calling a module function from a class method | Excel Programming | |||
Threaded Mode
