Hi,
I have this code to fit row heights in merged cells. This works ok but it takes a few minutes to run. I also have the problem of when I insert a new row or delete a row these cell references are then no longer correct. Can anyone adjust this formula to speed it up and use maybe a named range to reference these cells so they adjust when rows are inserted and deleted before the code is run?
Thanks in advance for any help with this!
Please Login or Register to view this content.
Last edited by colin7; 06-29-2019 at 06:17 PM.
Welcome to the board.
Please take a few minutes to read the Forum Rules, and then edit your post to wrap your code with CODE tags.
Thanks.
EDIT: Thank you.
Last edited by shg; 06-29-2019 at 05:12 PM.
Entia non sunt multiplicanda sine necessitate
Your merged cells horizontal, vertical, or both?
The merged cells go horizontally only column C to K
In the rare occasions when I do that, I make a spare column the same width as the merge area and put a formula in the same row e..g., =A2.
Wrap text and autofit row height.
On a side note. It looks like your array increases by 47 except "C534". Is that a stray or a slip of the keyboard finger?
Quite a good idea but as there are 200 cells it would annoy me knowing it calculating twice. My code actually works well, just the click of a button but my problem was it's not dynamic. I thought it would be quite simple for someone as good as yourself to make a few tweaks and maybe refer to a named range instead of every cell individually. Thanks for your help btw.
Hi, yes it should increase by 47 each time that is my mistake. A problem is I am inserting new rows or deleting rows so it could be more or less than 47 when I run the code.
Please Login or Register to view this content.
Thanks for your reply.
This seems to make the row height a lot larger than it should be plus it is longer to run than my original code.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks