A loop to read one cell and print to another

**maruchi** · 01-25-2010, 10:54 AM

Hi guys,

I am trying to program a loop in Excel VBA to read the first two characters of a cell in column A and, depending on the characters returned, to print something else in column B, then move to the next row up. What I have so far below is pieced together from little insights from over the web, but currently it does nothing. Not even error messages. It has more fields (if "XX" > print blah blah) but they are all the same, so only the first two iterations are shown here for clarity.

Please Login or Register  to view this content.

If you can see what is wrong with this code, or indeed, if you have a better idea for how I can tackle this problem, I would really appreciate hearing from you.

**StephenR** · 01-25-2010, 11:03 AM

maruchi: please add code tags (#) as per forum rules.

**maruchi** · 01-25-2010, 12:20 PM

Tags added. Sorry about that.

Does this mean a Forum Guru is looking at my request for help? *hopeful face*

**romperstomper** · 01-25-2010, 12:22 PM

You still don't appear to have added them...

**maruchi** · 01-26-2010, 06:35 AM

"left function" , if loops , macro , vba

...am I missing something?

**romperstomper** · 01-26-2010, 06:41 AM

Based on what you said you wanted the code to do, rather than what it appears to be trying to do, I think you want this:

Please Login or Register  to view this content.

Note: the above is what was meant by code tags!

**maruchi** · 01-26-2010, 06:52 AM

Ahhh

Now I understand. Sorry about that.

I am fiddling with that in my macro now.

Cheers,
Maru

**maruchi** · 01-26-2010, 07:48 AM

I adjusted the code to suit my sheet...and it worked! Once...now it has stopped working and isn't throwing up any error messages.

Please Login or Register  to view this content.

**maruchi** · 01-26-2010, 07:57 AM

Nevermind. Seems to have sorted itself out.

Cheers romper!

**lastever** · 07-19-2011, 11:38 AM

Sorry to reopen a closed thread.

I tried to use romperstomper's and when I use the code the macro only edits the first line and I am not receiving any errors as it does not move to the next line.

To test the code I created an Excel sheet with values in Column A with the same first two letters in the macro.

Do I have to modify the macro for excel 2007.

Thanks,

**romperstomper** · 07-19-2011, 11:45 AM

The code looks at column L to determine how many rows to process - did you adjust that?

**lastever** · 07-19-2011, 12:19 PM

Thank You for the quick reply.

I changed the range value from L500 to A6 because there are 6 values in Column A that I want to process.

I also tried to set Range(A1:A6) and that did not work either.

**romperstomper** · 07-19-2011, 12:22 PM

Change this:

Please Login or Register  to view this content.

to this:

Please Login or Register  to view this content.

**lastever** · 07-19-2011, 12:48 PM

I changed it and I now I get no output to cell B.

**romperstomper** · 07-19-2011, 12:57 PM

Then I need to see the exact code you are using or, preferably, a sample workbook.

**lastever** · 07-19-2011, 02:23 PM

Thank you for the help. After you said about changing the intLastRow I tried different combinations and this works:

Code:

Please Login or Register  to view this content.

A loop to read one cell and print to another

LinkBack

Thread Tools

Rate This Thread

Display

A loop to read one cell and print to another

Re: A loop to read one cell and print to another

Re: A loop to read one cell and print to another

Re: A loop to read one cell and print to another

Re: A loop to read one cell and print to another

Re: A loop to read one cell and print to another

Re: A loop to read one cell and print to another

Re: A loop to read one cell and print to another

Re: A loop to read one cell and print to another

Re: A loop to read one cell and print to another

Re: A loop to read one cell and print to another

Re: A loop to read one cell and print to another

Re: A loop to read one cell and print to another

Re: A loop to read one cell and print to another

Re: A loop to read one cell and print to another

Re: A loop to read one cell and print to another

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions