Macro that runs for every sheet stops working

[cooket4]

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

Please Login or Register  to view this content.

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

[JBeaucaire]

The only test you really need to do is check for the @ symbol. In my opinion.

Please Login or Register  to view this content.

[cooket4]

Thanks. Ill try that

I have gone throught the 'step into' mode and can actually see that its skipping the step in question, and the @ sign is physically there. This is what I dont understand, its there so why is it not being opicked up?

The cell in Excel is formatted as Genaral, which is the same as the others that have worked. All sheets are exactly the same, as they come from a template. The email address is in cell A1 on every sheet to, but the macro only recognises the @ for a handfull of pages. The latest workbook was 96 sheets, but 44 were only picked up. I have ran this macro months ago on workbooks with over 100 sheest and worked fine.

If this help the full code is:

Please Login or Register  to view this content.

[JBeaucaire]

Try my simple tweak first. Does it still skip?
On the sheet it is skipping, what is the exact value of that checkcell?

[cooket4]

Ill try it, but wont be able to till later in the month, as its busy at work with the year end audit. Ill let you know once I try it

Thanks