If you set a row to have a large row height (say 80) and check the '.RowHeight' property but you then hide it the rowheight will be 0 (as expected). If you then unhide the row the rowheight will return to 80.
My question is: how ? Were does Excel store this per row value ?
It is a stupid question for someone with some much Excel dev experience but I have never before needed to find the 'unhidden' height of a row when it was hide mode was 'True' without having access to the row before it has been hidden so I could record the height.
Any pointers would be appreciated.