I first need to find a value in a cell and then store the range of that cell.
the below code in VBA stores the email NOT the range of the cell.
thank you for any help - Eileen
Dim occurRange As Range
Windows(CARDfile).Activate 'cardholder summary file
With Range("Z:Z") 'EMAIL
Do...