Auto Fit Rows that are Merged.

Hi all,

I'm trying to auto fit rows that are merged. I have tried this code:

Please Login or Register  to view this content.

But end up with a "Run-time 91" error. "Object variable or With Block variable not set." The debug then highlights "If Target.MergeCells Then".

I'm new to VBA and am unsure how to personalise this VBA (it was written for someone else).
Thank you in advance

Hi AndyLitch,
Thanks for the feedback - was thinking no one would answer me!!

There appears to be a number of macros out there for it, but I just don't know how to personalise it for my sheet. I'm just too new to VBA to read the macro. I've tried the one in the original post and also this:

Please Login or Register  to view this content.

Thanks again for the feedback.

Hi AndyLitch,
Thank you again for posting. I've been absolutely stumped on this one. I ran the macro again, as you had amended it and it first comes up with an error that the 'argument is not optional'. i added Optional to the first line and now it comes up with the same error as before. This time the debugger pointing to 'If .MergeCells And .WrapText Then'.

Any ideas anyone? Thank you once again AndyLitch. Nic

bump no response

Hi AndyLitch,

Thank you so much for your reply. I have finally got the macro working on a tester sheet, but it resizes the each row within the merged cell to the size of the content. Therefore, the cell it resizes to is too big and has a heap of extra space in it..

I'll keep playing. I appreciate your time and assistance.

Regards, Nic