Forum Discussion
Solved
VBA sorting for flexible table
Howdy all, Just learning how to use VBA to do sorting Index Name Buyer 23 Apple William 56 Pear Jone 49 Banana May 31 Durian Andy Above list is not fixed. There m...
- Set uR = ActiveSheet.UsedRange
.SetRange uR
Thank you, but what if there is an empty row? Basically empty row should go to very bottom
| Index | Name | Buyer |
| 23 | Apple | William |
| 56 | Pear | Jone |
| 49 | Banana | May |
| 31 | Durian | Andy |
Empty rows within data are considered bad practice. Your data looks like a table, I advise to use Format as table, that will make this easier.