For Loop Issue

I have the following code:

Please Login or Register  to view this content.

The WksExists Function:

Please Login or Register  to view this content.

The code works fine but it only works for Sheet1 & DataImport2 but not DataImport3.

Hence why the loop does not copy the relavent data from the DataImport3 page onto a "Sheet3" in SOSCRMTasks.xls

I am working on an old file at the moment, but in reality the file is more than four pages now . e.g Sheet1, DataImport2, DataImport3, DataImport4 ....

thank You

Sorry,

What i want to know is why the loop is only doing DataImport2 and not DataImport3.


And yes i want the code to complete the same loop on all the sheets that start with DataImport and a digit

Hi,
Yes the sheet name is an exact match except the digit in the end.

Code is in a normal module i believe.

The interesting this is that it goes to DataImport2 but not DataImport3 worksheet

It's probably due to this line:

Please Login or Register  to view this content.

You have activated a different workbook and that sheet name probably doesn't exist in that workbook (your wksExists function assumes the activeworkbook). If you must activate it (which is unnecessary and inefficient) then make sure you reactivate the current workbook as soon as you have done what you need to so the loop can continue.

hmmm that sure is interesting!

And yes that worked just fine! cheers guys