Hi
I have a macro that runs through every sheet (no matter how many or few) of a workbook. It attaches each relevent worksheet to the relevent email within the sheet.
This macro worked fine, up untill a few months ago. The macro runs and attaches most sheets as normal, but it the email address in cell A1 which it looks up is no longer recognised
The bit of the code is
For Each sh In ActiveWorkbook.Worksheets
If sh.Range("A1").Value Like "?*@?*.?*" Then
I have looked into this and cannot find out to why the email addresses are not picked up, each is a valid address with @ in and all vary in length.
Why would the macor work as normal and then not recognise the email addresses? No error messege is returned, the macro just runs till its normal end.
Thank You
Bookmarks