Pass value of Object to String

SLogin2 is a string
sh7CellG is an Object (according to Error 424, Object required)

Im trying to pass the value of sh7CellG.Offset(0,1) to sLogin2

When I check the value of sh7CellG.Offset(0,1) via msgbox, its exactly what it should be.
So how do I pass the value of sh7CellG.Offset(0,1) to sLogin2?

Please Login or Register  to view this content.

(Ref: http://www.excelforum.com/excel-prog...e-dynamic.html)

Cant count how many times I changed
"sLogin2 = sh7cellG.Offset(0, 1)"
to
"sLogin2 = sh7cellG.Offset(0, 1).Value"
and had it fail.
Until I set the msgbox to "sLogin2 = sh7cellG.Offset(0, 1).Value", now it works all the time?
Oh well, solved is solved.

Small error that might be causing your problem:

Please Login or Register  to view this content.

Thank you!