Autofit Row Height of Cells (including merged cells) for Visible Rows Only

[AndiJanelle]

Hello,

I have a file that contains multiple groupings of merged cells, as well as many cells are not merged.

I need to be able to filter a column and have all of the visible rows auto-fit the height so I can view all the text within (some will be merged and others will not be).

I have found coding that works to autofit the visible cells that are not merged, but cannot find something that will autofit the merged cells, as well.

Any help will be greatly appreciated!

Andi

 

[Fluff]

Hi & welcome to MrExcel.
Have a look here https://contexturesblog.com/archives/2012/06/07/autofit-merged-cell-row-height/

 

[AndiJanelle]

Hey Fluff,

I tried that but to no avail....I am very new to VBA so it's difficult for me to modify the code provided within to make it work for me.

 

[Fluff]

I have never looked at the code, because I never use merged cells & so have no idea how it works.

If you supplied some more information, such as sheet name, ranges, which column is being filtered, maybe someone else can help.

 

[AndiJanelle]

Okay, I've listed cell references below:

The range of cells A2:A19 are all merged together as one (and there are about 5 lines of text within that group of merged cells).
The range of cells B2:B19 are not merged.
The range of cells C2:C19 are not merged.

How can I filtered for one (or more) cell in column B, and have the corresponding cell(s) in column A auto-fit the height so that all five lines of text are displayed?

Thanks again!