#2. try something like:

with Worksheets("Sheet1").Range("B:B")
.cells.Sort Key1:=.cells(1), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
end with

And watch doubling up those double quotes.

#1. Harald Staff once posted this:

Option Explicit
Sub showup()
With UserForm1
.StartUpPosition = 0
.Top = Application.Top + 142
.Left = Application.Left + 29
.Show
End With
End Sub

Maybe it'll help you position the userform--but I don't know what wavy means.

helmekki wrote:

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

--

Dave Peterson