About Us

Brent E

Thanks guys. I'll give these a try.

"Don Guillett" wrote:

Sub sortcoltoend()
Range("B1:B" & Cells(Rows.Count, "b").End(xlUp).Row). _
Sort Key1:=Range("B1"), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Brent E" wrote in message
...
Good day,

I am looking for a formula or VBA Code to dynamically sort a range of
cells
from Cell B2 down to the end of the Column regardless of length of data in
the column.

Thanks in advance for any ideas or suggestions.

Cordially,

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Two subjects: Column sort and True/False in cell	dilynn17	Excel Worksheet Functions	3	May 3rd 08 02:45 PM
data, sort option is grayed. how to sort on a column?	Steve Richter	Excel Discussion (Misc queries)	1	September 25th 07 03:25 PM
how to sort column with cell pairs	muggeschiss	Excel Worksheet Functions	5	May 31st 07 01:41 PM
How can I sort a column by the last positions of each cell	SHJOHN	Excel Discussion (Misc queries)	2	September 11th 06 06:15 PM
Can you sort text in a column, but leave cell color alone?	g wills	New Users to Excel	4	December 3rd 04 10:42 AM

Menu

About Us