Update cell value based on fixed and variable value

Hi,

I have a variable with a year called RYear which, for this example, has a value of 2013. I want my cell value to be "Period = 2013"

I want the macro to update the cell value with the following kind of code:

Range("A9") = "Period = " + RYear

However, that gives me a Run-time error '13' Type mismatch.

How do I have to change this line to make it work?

RYear is an integer if that matters.

Try this:

Please Login or Register  to view this content.

In the line of code you provided, change the + (plus sign) to & (ampersand)