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