Greetings,

I wrote the following code to automatically resize a worksheet range that
grows vertically.

With Range("RegionWorkingData").Resize(1, 1)
.Parent.Range(.Item(1), .Parent.Cells(Rows.Count, .Column) _
.End(xlUp)).Name = "RegionWorkingData"
End With

I can't seem to get it to work. When I run it I get the error message that
the Method 'Range of object'_Global' failer.

Can some one help me fix this code?


Thanks in advance for your help and guidance!!

Ray