Hi,

Select the range and then press Ctrl+G Special Blanks. This will select
all the blank cells. Now go to Format Row Height and input the desired
number. All the blank cells will now calibrate to the row height

Hope this helps.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Confused from Hertford"
wrote in message ...
Hi Guys, Thank you very much for your assistance yesterday - great help.
Need
to pick you brains on the following;

Worksheet now has alternate blank rows inserted but I now need to adjust
the
height of these blank rows on block - know how to to this individually but
can't get it to work on mass.

Thanks.