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.
Bookmarks