ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   embeded spreadsheet object (https://www.excelbanter.com/excel-programming/347942-embeded-spreadsheet-object.html)

peter

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