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.

Matthew Dyer wrote:

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

--

Dave Peterson

On Oct 7, 6:23*pm, Dave Peterson wrote:
+ 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.

Matthew Dyer wrote:

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

--

Dave Peterson

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