On Fri, 19 Nov 2010 06:53:58 -0500, "Jim Rech" wrote:


I must confess to having lost my way halfway through your discussion. But
just looking at the problem line of code:

.Resize .HeaderRowRange.CurrentRegion

I would think you'd need to do something like this because the Resize method
is looking for a number:

.Resize .HeaderRowRange.CurrentRegion.Rows.Count

That produces a type mismatch error. error 13

I can't figure out how it used to work.

I add data at times. Perhaps that changes the "table" declarations and
causes the error?