Hello,
I'm trying to have an email automatically sent using vba code. When an option is selected on a spreadsheet. What i would like is for the code to use the cell it is selected in to then look at the header to include this header in the message. I've seen various coding for this but nothing seems to be able to look over a set range of cells.
Information on the sheet;
It is a QA result tracker, Column A is the date.
The First row (s) are the product names.
Full range i need coding to work over is B5:AE35. The trigger will be when the user selects Red or Amber in a cell within the range.
I'm trying to have an email automatically sent using vba code. When an option is selected on a spreadsheet. What i would like is for the code to use the cell it is selected in to then look at the header to include this header in the message. I've seen various coding for this but nothing seems to be able to look over a set range of cells.
Information on the sheet;
It is a QA result tracker, Column A is the date.
The First row (s) are the product names.
Full range i need coding to work over is B5:AE35. The trigger will be when the user selects Red or Amber in a cell within the range.
