I have worksheets that have both hidden rows and hidden columns. When I use autofit row height and autofit column width the hidden rows and hidden columns are not ignored. For example, if cell G5 is non-blank and column G is hidden, the autofit row height will return a row height that does not ignore the hidden status of column G.
It would be really useful, and much appreciated, if there was an approach I could use in VBA that sets the autofit row height and autofit column width, ignoring hidden columns and hidden rows.
Thanks in advance