Hello,
Little help needed on a Sort command within VBA. I have it working within other workbooks but they are defined sheets, for this one I need it to run either on the ActiveSheet or 'fname' which is a variable used to hold the file name.
I have added a test workbook with some data in order to run and check. It's probably a stupid mistake but I just can't see it.
Please Login or Register to view this content.
Thanking in advance.
rng1, rng2 etc are actual range variables, not the names of ranges, so you just use rng1, not Range("rng1") and so on.
Rory
Thanks rorya. Corrected and changed all the 'Range("rng*") to just 'rng*' but still not sorting when the code is run.
Please Login or Register to view this content.
Last edited by mowens74; 09-11-2018 at 09:07 AM. Reason: Added further comments
It does sort for me, although you're treating the first data row as a header row so it won't move.
Sorted it, I know what the problem was. I used the variable 'rng4', between setting it and using it within the sort code, which changed the range. Something no-one could have helped me with as that code was given on this help request
Thanks again for the help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks