Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
I have trouble in the hidden sheet range
Hi,
I need to sort a bunch of values to ascending order. So i used t store the values in the HiddenSheet (Sheet1). I am using this code Sheet1.Range("A13:A35").Select Selection.Sort Key1:=Range("A13"), Order1:=xlAscending Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom The sorting is not working in the hidden sheet why? But the sorting is working if in current sheet Range("A13:A35").Select Selection.Sort Key1:=Range("A13"), Order1:=xlAscending Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom Is there any other way to acheived this. PLease do reply me soon Thanks Venkatesh -- Message posted from http://www.ExcelForum.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
I have trouble in the hidden sheet range
Hidden doesn't allow selecting, so use Don's second approach.
-- Regards, Tom Ogilvy "Don Guillett" wrote in message ... Hidden doesn't matter You cannot select a range this way. Use Sheets("sheet1").select Range("A13:A35").Select Selection.Sort Key1:=Range("A13"), Order1:=xlAscending, Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom OR to sort it without going to the sheet at all. Sheets("sheet1").Range("A13:A35").Sort Key1:=sheets("sheet1").Range("A13"), _ Order1:=xlAscending, Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom -- Don Guillett SalesAid Software "kvenku " wrote in message ... Hi, I need to sort a bunch of values to ascending order. So i used to store the values in the HiddenSheet (Sheet1). I am using this code Sheet1.Range("A13:A35").Select Selection.Sort Key1:=Range("A13"), Order1:=xlAscending, Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom The sorting is not working in the hidden sheet why? But the sorting is working if in current sheet Range("A13:A35").Select Selection.Sort Key1:=Range("A13"), Order1:=xlAscending, Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom Is there any other way to acheived this. PLease do reply me soon Thanks Venkatesh. --- Message posted from http://www.ExcelForum.com/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
I have trouble in the hidden sheet range
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
trouble with lookup in a range of cells. | Excel Worksheet Functions | |||
I need my Hidden Rows to stay hidden when I print the sheet. | Excel Discussion (Misc queries) | |||
Time Sheet for my org Im still having trouble | Excel Discussion (Misc queries) | |||
Saving hidden data with a worksheet (preferably without using a hidden sheet) | Excel Programming | |||
Problem pasting a row from a hidden sheet to the first free row on another visible sheet | Excel Programming |