Maybe specifying the worksheet would help:

with worksheets("sheet99").range("regionworkingdata")....

If that code is behind a worksheet, excel will assume that "regionworkingdata"
is a range on that sheet that owns the code.



Ray Batig wrote:
>
> 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

--

Dave Peterson