| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't create a new instance of the Range class
Hi all,
why is the following is invalid code? Sub foo() Dim MyRange As Range Set MyRange = New Range End Sub The New statement works with a class defined in a Class Module, but it looks like it doesn't work with classes in the Excel Object Model. Is there any workaround for this? Thanks, Best Regards Sergio Rossi |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| instance of class from dll, is it possible?? | Excel Programming | |||
| Name of Class instance | Excel Programming | |||
| Scripting Dictionary in a class instance | Excel Programming | |||
| Ensure single class instance but with multiple references to it | Excel Programming | |||
| Class Instance Identifier | Excel Programming | |||
Linear Mode
