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.
Please Login or Register  to view this content.
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.