Consolidating an offsetting code

**Actwentysix** · 08-28-2008, 01:14 PM

I am working on a code to transfer data from one sheet to another, but there are 75 lines that I am transfering.

The basics of the code is:

Please Login or Register  to view this content.

How do I make this loop 75 times.

I'm thinking it should be as easy as specifying a set number of times to loop, and in each loop have it at i+1 or something like that.

It works if I type it out 75 times, but then I look at a wall of text.

Any tips would be appriciated.

**Richard Buttrey** · 08-28-2008, 01:24 PM

Hi, and welcome to the forum.

Please take a moment to read the rules and guidelines. Thread subjects should be meaningful, and code should be wrapped with code tags.

'This should be easy' does not describe the problem and will not assist you in receiving replies. Please edit and correct this post and I'm sure someone will be along to assist.

Rgds

**Actwentysix** · 08-28-2008, 05:29 PM

After a bit more research on the subject, I believe to have found the answer:

Please Login or Register  to view this content.

And that seems to be getting the job done for me.

It's alot easier to manipulate the one line of text rather than the entire wall.

**Actwentysix** · 08-28-2008, 07:43 PM

It didn't work quite how I was needing, so if any of you have looked at this and have a word of advice.

After closer examination, the code I had used, wasn't exactly the code I posted above. so I reworked it a bit and have come up with the following solution, however, it doesn't seem to be working, and is giving me a mismatch error.

The following is the code that produces the error:

Please Login or Register  to view this content.

However, the following does work and I have used it successfully in the same workbook:

Please Login or Register  to view this content.

I'm not seeing the difference in why the former code is not working.

**Richard Buttrey** · 08-29-2008, 03:45 AM

Hi,

Probably because the values in column J on sheets 1 & 2 are not consistent. i.e. do you have numbers in one column, and non numeric text values, i.e. strings in the other?

HTH