Problem with loop

Hi
I have played arounf with this code to try and create aloop
The part I have highlighted in red is where I think I'm going wrong. No error is showing but nothing is happening either

Would anybody have any suggestions on how sort it

Please Login or Register  to view this content.

Thanks for your help

But it seems now that im getting a runtime error on the text highlighted below. I suspect I have denfined Icell2properly

I will try and put up a work sheet with the data but the data sensitive so I will have to create a worksheet with dummy data.

Please Login or Register  to view this content.

Try this instead:

Please Login or Register  to view this content.

Hi

I have been able to create a workbook with randon data in it

• The acutall output file from the data base has 26 different tabs in it, for the example i only have two int it

• The matmacro test.xlsm file is example of a file use to analysis certain tabs from the output file.

• The idea behind the loop is that the data in database is changing on a weekly basis and the there is a new export file every couple of days and i must ciopy paste fresh data in every time
• The loop in the macro is to read which tabs are on the "coverpage" i want to update from the output file. Im still having trouble with loop

Please Login or Register  to view this content.

Thanks for help