Html concatenate

[Jay3]

HI

Can someone tell me how to do the following.

I have a macro that generates an email based on information contained within excel.

When it generates the email it uses the following code to populate the subject.

.Subject = wsData.Range("C" & aRow).Value

I want to concatenate cells C and G from excel as the subject.

Can anyone tell me how to do this?

Thanks,
Jay3

 

[VoG]

Hi. Try

.Subject = wsData.Range("C" & aRow).Value & wsData.Range("G" & aRow).Value

 

[Jay3]

Thanks Ill try it.