The below macro, constructs an email based off of cells.
I need to create about 96 of the same but just changing the range as they are all on the same worksheet.
This issue is when i filter and arrange the cells by A-Z the macros all start of point at the wrong range.
If the line the macro is...