Hello,
I have the following code:No errors when running the macro. Everything works except this section:
Please Login or Register to view this content.
I'm trying to sort the sheet by column "I" ascending, but instead nothing happens. Not sure what I'm doing wrong.Please Login or Register to view this content.
Your sort code just sets the sort field. It does not apply it. Use this line to apply the sort
Or use this syntax to set and apply all in one line of code...Please Login or Register to view this content.
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.
Thanks AlphaFrog,
wks.sort.apply isn't working for some reason. The other line of code works sometimes and other times I'm getting an error stating, "The sort reference is not valid. Make sure it's within the data want to sort, and the first sort box isn't the same or blank."
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks