Hi there
1) Is ther a code to make a userform appear from top reight/left corner
in a wavy way ?

2) The sheet that contain the range needs to be sorted must be
activated .
I nedd to make my sort without activating the sheet that conatain the
range, cuz this sheet is very hidden and I want it to contiue to be
hidden.
Is there a soultion to sort my range in the hidden sheet without
activating this sheet ?
"
Code:
--------------------
Worksheets(""Sheet1"").Range(""B:B"").Sort Key1:=Range(""B1""), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
--------------------
"


--
helmekki


------------------------------------------------------------------------
helmekki's Profile: http://www.excelforum.com/member.php...fo&userid=6939
View this thread: http://www.excelforum.com/showthread...hreadid=487354