Set row height property

Hi All,

I have written the code below to run through several worksheets and set the row heights to that of a cell value in the same sheet (unable to use autofit as some cells are merged). I am currently listing every single row and wondered if there was a more efficient method. See snippet below

Please Login or Register  to view this content.

try this:

Please Login or Register  to view this content.