How to make a macro in excel that will independently set the height of the merged cells?

Question

Visual Basic

We need a macro that will fulfill the following conditions for the merged cells:
if there is no text, then the height is 0 (the merged cells are hidden);
The size increases as the merged cells are filled with text and actually decreases as they are removed into the flesh until they are hidden.

Answer 1

answer HERE