Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range Prompt
Hi I have the following code which is working well, but I'd like to improve
on it. Ideally I would like a msg prompt to select "AK2" Perhaps I could name the range AK2 as I have "RANKING"? Not sure about msg prompt? If anyone could help, I would appreciate it. Kind Regards Tanya Private Sub CommandButton3_Click() UnProtect_Workbook Application.Goto Reference:="RANKING" ActiveWindow.SmallScroll Down:=-9 'Sort by Sem-2 Rank Selection.Sort Key1:=Range("AK2"), Order1:=xlAscending, Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal ActiveWindow.SmallScroll ToRight:=2 Protect_Workbook End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
save prompt for user exit, but no save prompt for batch import? | Excel Discussion (Misc queries) | |||
Help on Prompt | Excel Worksheet Functions | |||
Prompt for Value | Excel Programming | |||
Prompt for Value | Excel Programming | |||
Prompt for a range to apply code to | Excel Programming |