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
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