In this publication titled excel autofit row height merged cells vba, I have provided a complete image from start to finish ,Please look below