Email referenced email

[aznprod517]

Hello,

I am trying to have the excel sheet email out certain data when values in certain cells have changed. I am able to have it reference the column header easily, but is there a way to reference the row it is in without needing to create a new section of code, because this could grow to include several hundred lines. Is there a way to use variable referencing for columns as well? Right now I am hardcoding in the columns.

This is what I have so far:

Please Login or Register  to view this content.

Any advice on this would be greatly appreciated.

Thanks

[Leith Ross]

Hello aznprod517,

I updated your macro. It will now show the column where the change took place.

Please Login or Register  to view this content.

[aznprod517]

Thank you for your help! It really helped out!