Code loop in Excel 2007

Hi,

I'm trying to simplify some code by running a loop rather than setting the code to run on each of a number of worksheets within a file. The code works for each worksheet individually and is as follows:

Please Login or Register  to view this content.

This continues with Sheets("J2").Select, and so on for up to 20 different sheets. This code takes data from the first and second sheets in the file and enters it into specified cells; currently, this method of applying the code to each worksheet works, and gives the correct outputs. I've tried to condense the code by using a loop, shown below:

Please Login or Register  to view this content.

But this gives me blank output. I am fairly new to this, although I did write the original code myself.

Can anyone give me any pointers please?

Hi,
First pointer: avoid Goto statements, except in On Error Goto lines. It makes your code really hard to follow (especially when we only have part of it) and is almost always unnecessary.
Second pointer: A sample workbook showing your layout (dummy data preferably) so we can see exactly what is happening, together with a description (in plain English) of what you actually want to happen makes our lives a lot easier!
Third: proper code indentation makes it a lot easier to read, and a few comments explaining what is going on wouldn't go amiss.

At a rough guess, I think you want something like this:

Please Login or Register  to view this content.

I suspect that's because I forgot an important bit while tidying up:

Please Login or Register  to view this content.