![]() |
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 |
All times are GMT +1. The time now is 03:38 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com