VBA Variable Range Sort
Hello, I am trying to setup a macro to sort a variable range. I need to sort from a static range G14:O14 to down. In the example, I have selected range G14:O100, but i could have more rows, 105, 110 etc., so i would need to make it variable. Here is what i have:
Please Login or Register to view this content.
Last edited by arlu1201; 04-10-2013 at 09:47 AM.
Please Login or Register to view this content.
Slight modification to rcm's code above (excluding the Select statements)
Please Login or Register to view this content.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Yes arlu1201 is right!
Thanks arlu :-) Tried it too, it shows a problem at ".Apply"...
What is the error you get?
Run-time error '1004'
The sort reference is not valid. Make sure that it's within the data you want to sort, and the first Sort By box isn't the same or blank.
You have no headers in your data right? Is the starting data set from G14:O14 having any blank cells?
Well, yes, the range G14:O14 is already the data itself. I have headers in the range G12:O12, G13:O13 is an empty range (for the optic only). My current data ends at G79:O79 and then i have entered still some formulas till G100:O100, that it will get the new data set during the next update. Makes sense?
Thanks
Can you upload a sample of your data to make it more clear?
Hi Arlu1201, sorry, it took some time to answer, too much stress last days.... See my "fast made" example attached. Thanks!
... forgot to mention, that my team names are vary from week to week, so i would need to have this range as variable... Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks