Sort a Range in a Hidden sheet
 

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

Sort a Range in a Hidden sheet
 

#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

Sort a Range in a Hidden sheet
 

Thank u 4 reply

Wavy means moves like wav...i.e.
i mean the userform should appear as forms appear in the powerpoint
app

i.e. userform appears small in top left corner and moves to the center
slowly and becomes larger and larger

Is there a code to do this with userform in Excel App ?


--
helmekki


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

Sort a Range in a Hidden sheet
 

Not in regular old VBA (as far as I know), but maybe some fancy, smancy windows
API stuff can do it. (But it's way beyond me!)

helmekki wrote:

Thank u 4 reply

Wavy means moves like wav...i.e.
i mean the userform should appear as forms appear in the powerpoint
app

i.e. userform appears small in top left corner and moves to the center
slowly and becomes larger and larger

Is there a code to do this with userform in Excel App ?

--
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