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