VBA gurus,
By being so active here, I am learning some VBA coding. Mostly by copying and modifying code to suit my needs.
I needed to figure out a way to:
1. Look at five columns [each is filled to different size by another macro],
and if row 1 in the respective column has text in it,
2. Find last used row in that column and
3. Sort each column alphabetically from Row 4 to end of that column.
In the attached example I have a macro "sort".
It works, but as you can see, I am using a lot of workarounds.
In hopes of learning proper syntax; to loop though columns B-F and selecting appropriate range and then sorting the range; I am asking someone to look at the code and streamline it so its more efficient.
Here's the code:
Thank you for you help.
modytrane.
Bookmarks