Thanks Dave,

I added the worksheet reference as you suggested, however, I get the same
error. This macro is in a module and is activated by a button on a
worksheet. Any more ideas?

Thanks again for your help!!

Ray


"Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
news:43FFB758.5343C128@verizonXSPAM.net...
> 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