Weird VBA behavior.

[kdtunstall]

Okay, this will be strange.
I have a couple of tabs in an excel workbook that all have merged cells and I am using VBA to auto-fit and hide rows.
On one of the tabs, the VBA works.
But on the other tab, the very first cell fails to auto-fit, but the second cell works properly.

Code for first tab (this one, "b4" fails, but "b8" works:

Please Login or Register  to view this content.

On this tab, the code is essentially the same.
All of it works properly.

Please Login or Register  to view this content.

You'll note, the section that is auto-fitting is EXACTLY the same.
The tabs have the same formatting, same column width, same same same.
I can even copy / paste the VBA from the working tab, to the one that doesn't work, and it will fail again.
Am I going nuts here? Is there something obvious that I am missing?

I actually have a third tab with very similar code with different cells referenced. It too works properly.
The workbook is much to large to upload and contains sensative data.

[romperstomper]

What is actually in B4 on the tabs?

[kdtunstall]

Yes sir, the top part is exactly the same.
It should produce something similar to this:

Attachment 858009

However, the rows need to expand as the information in those boxes increase.
Work fine on all of my tabs except this one. Was even thinking of deleting the tab and starting over if I can't figure this out.

[romperstomper]

That attachment doesn't work for me. You need to attach pictures the same way you attach workbooks.

But "yes" isn't really an answer to "what?"...

[kdtunstall]

Oh forgive me.
The cell contains a reference to another tab (on all, they are the same)

=UPPER('Depo Order'!D7)

[kdtunstall]

In this case, (and there is a header not shown on the image) it would be the first party to the suit (or cause - if I'm being formal).
a.k.a. - the plaintiff.

[romperstomper]

Have you tried copying and pasting that cell from a tab that works to the one that doesn't just to remove any formatting differences?