Forum Discussion
wktay
Jan 09, 2024Copper Contributor
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...
- Jan 10, 2024Set uR = ActiveSheet.UsedRange
.SetRange uR
wktay
Jan 10, 2024Copper Contributor
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 |