Func - AutoFit Row height on Excel Merged Cells

Post your working scripts, libraries and tools
Tre4shunter
Posts: 32
Joined: 26 Jan 2016, 16:05

Func - AutoFit Row height on Excel Merged Cells

10 Oct 2017, 21:00

Hey guys -

Had to do this today for a project - thought it might be useful as you cannot use Excel's built in features to Autofit Row heights with word wrap enabled on cells that are merged.

This function will allow the cell range you specify to autofit the row height so all text is visible in a merged range.

Here is a demo of Excel Failing to do so VS this function being awesome. NOTE: i left screenupdating on just for demo - use in script will not show the rows resizing/adjusting, only final product.

Thanks and Enjoy!

Excel Failing:
https://imgur.com/a/dWwm1

AHK Being Awesome:
https://imgur.com/a/hOLOu

Script:
Function with usage

Code: [Select all] [Expand] [Download] GeSHi © Codebox Plus

Return to “Scripts and Functions”

Who is online

Users browsing this forum: No registered users and 12 guests