Pass value of Object to String

[Rick_Stanich]

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)

[Rick_Stanich]

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.

[Pichingualas]

Small error that might be causing your problem:

Please Login or Register  to view this content.

[Rick_Stanich]

Thank you!