I am using the code provided by Leith Ross, see link.
http://www.excelforum.com/excel-prog...ing-array.html
the only difference is, I added this line of code to select only cells with text or formated as text. It is also the first line to be run.
the code works great when I select multiple rows in a single selection (rows 1-10 for example), but if I select my rows with multiple selections (rows 1-10, 12-13, 20-30....) only the first selection works and all the others are trashed. The attched picture shows what I am talking about.
flip rows error.PNG
Is it possible to modify the code so that I can have more than one selection when I flip my rows? if so how?
Thank you for the help.
Bookmarks