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
Bookmarks