Help making Vloop up go to the next cell when using For Each

**Keatonyoung** · 10-03-2012, 05:35 PM

Hi,

I am trying to use vba to insert a column then insert a Vlookup which will compare the values in column D to the second sheet and return the text in the 3rd row to column C and repeat

So, the problem I am running into is that it stops after the first 1 or 2 rows when it has about 4000 more to go..

Please Login or Register  to view this content.

Thank you!

See file here
Test Excel.xlsm

**rylo** · 10-03-2012, 05:59 PM

Hi

From the code it is not obvious exactly what is the current sheet when you are running things, but you aren't actioning sheets("Start Here") properly. Try

Please Login or Register  to view this content.

Also, can you please edit your post and put code tags around the code snip you have shown. Makes things much easier to read.

rylo

**Keatonyoung** · 10-03-2012, 06:14 PM

Thank you for the reply. It still is only populating the first cell.

**rylo** · 10-03-2012, 06:53 PM

Hi

Put up an example file with the macros and some non sensitive data so we can get a better view of what you are doing.

rylo

**Keatonyoung** · 10-04-2012, 09:07 AM

Added example in original thread.

**Keatonyoung** · 10-04-2012, 09:16 AM

Test Excel.xlsm

See attachment above

**rylo** · 10-04-2012, 06:17 PM

Hi

OK, try this

Please Login or Register  to view this content.

rylo

**Keatonyoung** · 10-04-2012, 06:22 PM

Worked perfect! what was the issue?

**rylo** · 10-04-2012, 06:33 PM

Hi

A few things.

1) the .range was missing to make sure it was working within the with block.
2) Once you inserted the blank column into C, you had to move the range selection block to D not C as there was nothing there (this would have been the biggest issue)
3) You were trying to put the vlookup formula into the cell below the one that was being actioned.

rylo