Sorting with Excel VBA
HTML-код
- Опубликовано: 6 окт 2024
- How to sort data with Excel VBA. This gives a few examples of how to sort a single column in ascending and descending and moves onto sorting multiple columns. File at the following address.
www.thesmallma...
i can't believe it. in all my years of programming vba, c++, php, etc.... i never knew about the [A2] bracketed hard confinement of vba. i have written many dynamic models so it wouldnt have helped completely, but all my utility tabs and tables that don't change dimension, would have saved my fingers.
Awesome. Added to your bag. That makes me happy. Thanks for the comment. Enjoy.
very simple code thank you
You are welcome Mahesh
Will this work when new data is entered?
Yes as you add new data the Current Region will grow. So it is fully dynamic.
not working for me 😞
@thesmallman
0 seconds ago
Please follow the steps exactly as I do them. If we are using Office 365 our versions of Excel are the same so it it does not work for you then you have not done exactly the same steps as what I have done. Re do the video and follow the steps precisely. 😀
Ik heb het gevonden op een ander manier, maar van mij moest heel de tabel gesorteerd worden. Alleen de eerst kolom gaat mee en dat mag niet. Ik bekijk nog eens je filmpje.
Dat is geweldig maat. Ik ben zo blij dat je een manier hebt gevonden. Het allerbeste met je leerproces.