I am trying to adapt this code to sort worksheet "DriverDetails" by column A after an addition of information. The sub SortDetails() is called by the update macro.
It is not sorting and I cant see why. Code should take account of any number of rows and any number of columns. Data has a header row.
Any pointers appreciated....
Please Login or Register to view this content.
Hi,
Did you checked what values of LastRow and LastColumn when sortdetails() starts?
May be this way:
Please Login or Register to view this content.
Last edited by kasan; 02-01-2017 at 06:23 AM.
Hi Arkadi, Can I do that with
MsgBox "A1:" & Cells(LastRow, LastColumn).Address(0, 0)
yep I can so that is reading correct range "A1:AT77"
so the alphabetical sort isn't working because it is not referencing column A as sort column
Last edited by nigelog; 02-01-2017 at 07:11 AM.
Sorted
Please Login or Register to view this content.
How about this ?
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
A lot neater code BakermanThanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks