Help with Macro

[Macker72]

Hi
This line works in my email macro until i add the little bit at the end, i.e.: (& Range ("C4").Value:


Application.Dialogs(xlDialogSendMail).Show Array("anon@v1.anon.at", "anon2@anon.ch", "anon3@anon.ch"), "Weekly Stats - " & Range("C4").Value

I need the reference to Cell C4 though, this is critical.

Thanks
Mac

 

[jfuoti]

What error message are you getting? Is the value in C4 text or numeric? If it is not text you might have to convert the value to text in order to concatenate it with the text in the first part.