I receive a worksheet where many rows have different sizes. Most of the rows with a height of 1 or less are typically blank and can be deleted.
I would like to create a Macro that allows me to select the Range first (by Highlighting 1st ~ I'd like to select contiguous range of cells) and then have the macro cycle through the selected range and delete the rows that have a height of 1 or less. [so for example, if I have 100 rows in a work book and I select the rows 5 through 85 and Rows 12, 19, 33, 55 have a height less than 1, I would like to delet those rows].
Thank you