Automating row height

[Pennington]

I have a macro that wraps text in a protected cell containing text imported
from another sheet. When the text in the other sheet is deleted, the
protected cell goes blank but the row height remains as before. I can run
another macro to autofit row height but is there a solution whereby when the
cell is made blank the row height returns to normal without running another
macro?

 

[Frank Stone]

hi,
why cant you add a line to your current macro that
autofits the row just after the delete data. no second
macro needed.