Formula Assigned To Variable

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Assign variable value across files 1
Use Value of Dynamically Created Variable 5
Assign Selection to a Variable 2
in a macro how to make a part of the formula a variable 3
Calling a sub 3
Assign multiple cell's values to a variable 2
Assigning a cell address to a variable 1
Find Cell Value and Activate 1

Back
Top