MeganDHarris
New Member
- Joined
- Sep 6, 2018
- Messages
- 2
I need assistance developing a macro that will clear cell contents based on it's text alignment. I have a column in my excel sheet that contains both project names aligned to the right and subtask names aligned to the left. I need the column to be separated into 2 columns - one with just the project names and and with just the subtask names. Is there some simple vba code that will copy the column then delete all the left aligned text out of the first column and all the right aligned text out of the second column? Any help will be greatly appreciated - thank you!!!