Thanks, Ray! That will really save me a lot of work!!

"Ray A" wrote:

one way
highlight the range press F5click special...click the radio button
"Blanks"OK Now press ctrl+- and delete rows

"JP6262AMY" wrote:

Data is imported from an external source and contains numerous blank rows
within the data. How can I remove the blank rows without having to select
each one? There are sometimes hundreds of them. Thanks!