combining text and variable in a .value

  • Thread starter Thread starter Matthew Dyer
  • Start date Start date
M

Matthew Dyer

First, I want to thank everyone for all their help throughout today. I
appreciate it more than you can imagine!

I want my macro to output the text "Max DPD=" and the value of the
variable of Maxdpd all in the cell K3. This is what I've attempted,
but of course it doesn't work. Why not? How can I get it to work?

Range("k3").Value = "Max DPD=" + Maxdpd
 
+ means to add numbers.
& means to concatenate strings

Sometimes VBA will forgive you and allow you to use + if it can guess (not
always correctly) what you want to do.

I'd try:

Range("k3").Value = "Max DPD=" & Maxdpd

If that doesn't work, you'll want to be more descriptive of how it fails.
 
+ means to add numbers.
& means to concatenate strings

Sometimes VBA will forgive you and allow you to use + if it can guess (not
always correctly) what you want to do.

I'd try:

Range("k3").Value = "Max DPD=" & Maxdpd

If that doesn't work, you'll want to be more descriptive of how it fails.
Click to expand...

Dave Peterson to the rescue... AGAIN! Thanks for all your help!
 
Back
Top