Formula Assigned To Variable
 

I need some help and I can't find the correct syntax. Here is what I have

MonthES = CONCATENATE(0, Month4

I want to assign the value of the formula above to the variable MonthES. I don't see why this shouldn't work. I would think it is only a syntax error, but I can't seem to find the answer

Thanks for your assistance

Formula Assigned To Variable
 

James,

There's no Concatenate function in VBA. Nor is it supported using
Application.WorksheetFunction. Use the Concatenate operator (&) instead:

Monthes = 0 & Month4
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"James Stephens" wrote in message
...
I need some help and I can't find the correct syntax. Here is what I
have.

MonthES = CONCATENATE(0, Month4)

I want to assign the value of the formula above to the variable MonthES.
I don't see why this shouldn't work. I would think it is only a syntax
error, but I can't seem to find the answer.

Thanks for your assistance