i have the below where I am searching for an Up/Down arrow character to find the last column sorted, and then to resort on that column (as part of a larger pivot change script).
If I place the LastSortColumn Variable outside the case statement, the code will execute without error. But when trying with the case select, I get an Run Time 5; Invalid Procedure call or argument.
In trying to trouble shoot, the message box "Found" pops up, so it finds the character just fine, but then the select doesn't work?
Can anyone offer some ideas or thoughts where I am going wrong?
and I have both variables c and LastSortColumn being defined as a Range at the top of script.
Please Login or Register to view this content.
Bookmarks