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
instead of .SetRange Range("A1", Range("A1").End(xlDown))
use
.SetRange Range("A1").CurrentRegion
use
.SetRange Range("A1").CurrentRegion
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.
- Set uR = ActiveSheet.UsedRange
.SetRange uR- Thank you very much