Application-defined or object defined error when setting string value

[lordterrin]

Hi There,

I have the following code and I cannot figure out what's wrong:

Please Login or Register  to view this content.

There's more code below that works fine so I won't copy it in.

I am getting an error when I try to assign Cells(tRow,27)'s Offset of (0,-24) to the variable SOCheck

I keep getting errors on the bolded line above- why is this wrong????

[xladept]

Probably:

Please Login or Register  to view this content.

[lordterrin]

Yup - that worked, and it makes sense. Thanks very much!

[xladept]

You're welcome!