| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
trim a range object
I have a nice range defined and I want to trim up all the cells.
Can't I do something like Application.WorksheetFunction.Trim(rng) or Application.WorksheetFunction.Trim(rng.Value2); or .... I can build a loop, but geezzz, these range objects are too nice to have to fool around like that. Is there an enumerator somewhere. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find End in Undefined Range Select Range Trim | Excel Programming | |||
| Trim the entire range | Excel Programming | |||
| returning pivottable object from a range object | Excel Programming | |||
| Range object to Array object conversion | Excel Programming | |||
| Range object to Array object conversion | Excel Programming | |||
Threaded Mode
