You are confusing the range with its name:

Set G = Worksheets(E).Range("B21")
Set G = G.End(xlRight)
--
Gary''s Student - gsnu201001


"Terry" wrote:

I have set "G" as the a range.
In the later part, I need to use "G" as a reference to set itself as another
range.
what is the correct syntex?


Set G = Worksheets(E).Range("B21")
...
Set G = Range(G).End(xlRight) <-----Error occurs here

Please help!