Autosize merged rows

[Cneidert]

Hello out there!

Thank you for your help in advance.

I have merged rows that I want to autosize. I've ready what I can find here, but nothing works. One thread said he/she found a solution, but the code was missing.

Can anyone help me? It's rather urgent.

[Medpack]

The only solution is to write a piece of code that unmerges/resizes the cells/and then remerges the cells. It's rather complicated depending on the length of your entry and how many cells are merged...

If the entries are a set size, or you don't mind potentially having additional spacing, you can just set the cells to a default size.

[Cneidert]

MedPack

Thanks for your reply. I can't have a default size unfortunately.

Nor do I know how to write code. I just thought someone might have a macro I could cut and paste.

Does anyone out there have such a thing?

Many thanks for any assistance.

[sarails]

the basic code to autosize rows is this code

Please Login or Register  to view this content.

It will auto fit column A only if you want to add more columns change, then quote inside the brackets to meet your requirements i.e. ("B:K") will do all columns from B through K.

This code will autosize any cell within the columns, if your merged cell overall is smaller than the combined cells above or below it their auto width takes precedent.

hope this helps

Iain

[Cneidert]

sarails:

Thank you. I am looking for something that autosizes rows; perhaps this could work with rows also.

I can't require anything to be changed in the macro code to apply it to different cells than those that are specified in the macro. This is a workbook that will be sent out to many others like a form, and they worn't be able to do that.

Thanks for the help.

I am beginning to think this is impossible to do in Excel.

Anyone else have anything?