Hi,
I have some code in a macro:
But, two things needs to be changed: the key (wich in my example is K:K) must be picked from a cell B4 (wich has variable content). And: order can be ascending and descending, depending on the value in B5 (1 or 2).
Please Login or Register to view this content.
How should I change this?
Last edited by jgmiddel; 10-10-2008 at 09:30 AM.
Hello jgmiddel,
It would help to have a little more information about the contents of cell B5. Will it be text like "K:K" or an actual range address like $K1:$k200? Also, what version of Excel is the code from?
Sincerely,
Leith Ross
The content of B4 is the column, for example 'K:K', or 'D:D'. De value of B5 is 1 or 2. I am working in Excel 2007.
Hello jgmiddel,
You could code it this way...
Sincerely,Please Login or Register to view this content.
Leith Ross
He, this works very fine!. Thanks a lot!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks