Error 2015, but if I try the formula in my worksheet it returns a value

[vbaNumpty]

This code is giving me error 2015

togGle = Evaluate("=RIGHT(addMe.Offset(0, 17).value,6)")

Despite returning a value for the offset value:

Also doing the Right formula in the worksheet on the same cell returns a value.

 

[Fluff]

Try

togGle = Evaluate("=RIGHT(" & addMe.Offset(0, 17).value & ",6)")

 

[vbaNumpty]

Try

togGle = Evaluate("=RIGHT(" & addMe.Offset(0, 17).value & ",6)")

Making progress I think, it is now an error 2029!

 

[Fluff]

Change Value to Address

 

[jasonb75]

Or you could use

togGle = Evaluate("=RIGHT(""" & addMe.Offset(0, 17).value & """,6)")

or even simpler

togGle = Right(addMe.Offset(0, 17).value, 6)

Evaluating RIGHT as a worksheet function seems kinda pointless when vba already has the same function as native.

 

[vbaNumpty]

Or you could use

togGle = Evaluate("=RIGHT(""" & addMe.Offset(0, 17).value & """,6)")

or even simpler

togGle = Right(addMe.Offset(0, 17).value, 6)

Evaluating RIGHT as a worksheet function seems kinda pointless when vba already has the same function as native.

Jason to the rescue! Thanks, I didn't realize vba had a RIGHT function natively.