Posted to microsoft.public.excel.programming

ADK[_2_]

external usenet poster

Posts: 2

Determining current sort

Is there a way to take a range (say: A7:S10000) and determine what the
current sort order is? I have a userform that allows the user to select which
column they wish to sort by but would like to display on the user form what
the current sort by column is. The columns I allow the user to sort within
the range indicated above is B,C,D,E,G,H,I,P,Q,R

Thanks,

ADK

Using Excel 2000 and beginner at vba

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Sort Current Worksheet	[email protected]	Excel Programming	6	April 25th 08 08:34 PM
Sort doesn't recognize current region	RobWN	Excel Worksheet Functions	2	September 7th 07 10:48 PM
determining resolution of current screen display	Graham Whitehead	Excel Programming	2	August 7th 06 11:13 AM
Determining current Time Zone In Excel	Shaun_C	Excel Discussion (Misc queries)	2	April 7th 06 06:29 PM
Determining the current row and col	k483	Excel Discussion (Misc queries)	2	November 25th 05 05:50 PM

All times are GMT +1. The time now is 05:50 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us