I wrote the following code to format a specific spreadsheet that gets strange resizing everytime the data refresh is done.

Please Login or Register  to view this content.
However, in that Range A for the last line, there are a few pesky merged cells that span columns A and B that won't autofit height. How do I get this to recognize merged cells?

Thanks!