VBA for Numbervalue function?

[Mr Retirement]

Hello -

I am trying to use vba to determine if one cell equals a piece of another cell. My issue is that the 'piece' of the cell (using a Right formula) is registering as text whereas the other cell is a numeric value. I can solve this by using Numbervalue function but I don't know how to replicate this in VBA.

Cells(5, i).Value = Right(Sheets("FindTab").Cells(1, y), 5)

Any help would be great!

Thanks,
Mr R

 

[JoeMo]

Try:

Cells(5, i).Value = Val(Right(Sheets("FindTab").Cells(1, y), 5))

 

[Norie]

There are various conversion functions in VBA, see here.

 

[Mr Retirement]

Thank you, Joe! Worked perfectly.

 

[JoeMo]

Thank you, Joe! Worked perfectly.

You are welcome - thanks for the reply.