| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range and Cells method
I am trying to build a range using the following method;
CntRef4 = xlApp.Range(xlApp.Cells(RowRef, ColRef), xlApp.Cells(z, ColRef)) Where CntRef is Range, RowRef,ColRef and z are String. RowRef,ColRef and z all contain values when I do a mouse over, however CntRef =Nothing. If I Change CntRef to String it reads ="" How should I look to clear upo this problem |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Set range with Find method | Excel Discussion (Misc queries) | |||
| Range.delete method | Excel Programming | |||
| Adding named range gives error "method range of object _Global failed " | Excel Programming | |||
| Pass a range to a method? | Excel Programming | |||
| Sort method of range | Excel Programming | |||
Threaded Mode
