sort data with vb

xyon

New Member
Joined
Nov 26, 2005
Messages
1
Hi all,
I am trying to sort columns in a worksheet using VB.
I have found a little info on it but its not as straight foward as I first thought and I cant get any of the examples I found to work in my situation(all I get are lots of errors and I've tried modifying it without resluts).
Basically I have worked out how to select the range in VB but now I need to sort the selected range.
On one sheet I need to sort the range a3:a53 and on the other sheets I need to sort the range b2:j52 using column c to sort ascending.
Any help would be greatly appreciated.


xyon
 

Some videos you may like

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

BrianB

Well-known Member
Joined
Feb 17, 2003
Messages
8,127
The best way to start is to record a macro of your process and copy/paste the code in a message saying what problems you get.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,678
Messages
5,573,608
Members
412,539
Latest member
itchy00
Top