Formula Assigned To Variable

J

James Stephens

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
 
E

Earl Kiosterud

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 said:
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.
Click to expand...
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.
 
Top