Send Email of Target.EntireRow values

[travisc]

I'm trying to write a macro to email the contents of the entire row for the cell that's been modified... I've already got the code written to send an email with just the Target.Value for the cell that's been changed...

rng = Target.Value

Puts the value of the cell that's been changed in the body of the email

rng = Range(Target.EntireRow).Value

doesn't put anything in the email... Any help is appreciated.

Thank yoU!

 

[Joe4]

That is not a valid statement. You cannot assign the values of a multi-cell range to a single variable like that.
You would need to iterate through the range, maybe assign it to an array.

How exactly do you want it to look anyway, if you are dealing with a multi-cell range?
Can you post a simple example of one row's data, and what you want the email body to look like?