Hi, i have a simple table. Consist of S/n, name, amount and sales. I tried to use VBA to sort the amt, however, the Serial Number (S/N) get sorted as well. Is there any way to sort all except the S/N column?
Hi, i have a simple table. Consist of S/n, name, amount and sales. I tried to use VBA to sort the amt, however, the Serial Number (S/N) get sorted as well. Is there any way to sort all except the S/N column?
A Table will sort all rows together. This will unlist the table, sort columns B:D, then relist the table.
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks