Gary Keramidas schrieb:

ActiveCell.Value = "Wow, " & ws.Range("A1").Value & "calls in one day is
fantastic!"

I think it's better to use this code:

ActiveCell.Value = "Wow, " + ws.Range("A1").Text + "calls in one day _
is fantastic!"

AFAIR is '&' the operator for 'Binary AND'. To concat strings in VBA,
you need the '+' operator.

And I found that using the .text property of a range saves you some
hassle, if the content of the cell can be interpreted as something other
than a string.

CU,
Christian