Row height based on cell value

Hello,
I am trying to find a macro to adjust the row height depending on the value in column B
More specifically if column B contains the value "#Break" I need to adjust the row height to = 9.75 (13 Pixels)

It is a fairly basic one but I have not been able to find any answers by searching through the forum

Can anyone help?

Hi

How's this

Please Login or Register  to view this content.

rylo

Like a dream! Thankyou Rylo. :D
If I wanted to delete those rows, would that be similar?

Hi

Sure, but you have to run the loop backwards (

Please Login or Register  to view this content.

) and then

Please Login or Register  to view this content.

rylo

Like this?

Please Login or Register  to view this content.

no joy, I have made an error somewhere along the line

please forgive my lack of technical understanding, I am still learning

Hi

Sorry, my bad. Delete line should be

Please Login or Register  to view this content.

rylo

Rylo, you sir are a legend. Thankyou