| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
embeded spreadsheet object
Hi,
I have embeded a spreadsheet object in a user form. I am having trouble sorting the data in this object. UserForm1.ssprograms.Range("a3:f64000").Select Selection.Sort key1:=UserForm1.ssprograms.Range("b3"), order1:=xlAscending, _ header:=xlNo, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom the debug error is "The text you entered is not a valid reference or defined name." UserForm1.ssprograms.Range("b3") returns the contents of b3. is the systext wrong?? peter |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I remove an embeded flash object from a spreadsheet? | Excel Discussion (Misc queries) | |||
| flash player object embeded | Excel Discussion (Misc queries) | |||
| protect embeded object | Excel Discussion (Misc queries) | |||
| protect embeded object | Excel Worksheet Functions | |||
| protect embeded object | Excel Programming | |||
Threaded Mode
