How to use a variable cell reference in a loop?

**mullock** · 02-12-2013, 10:58 AM

Hi All,

Having a basic issue with declaring a cell value in a loop while trying to step through cells to count the number of "/" in the string. I can step through the cells, but I am not able to set a variable cell attribute when using Len() or Substitute().

I have tried:

Please Login or Register  to view this content.

And also have tried using

Please Login or Register  to view this content.

Neither works?? Any Ideas?

BTW it works fine with a single cell reference "A1" I just need to loop this through some columns on a single row.

Please Login or Register  to view this content.

**patel45** · 02-12-2013, 11:43 AM

Please Login or Register  to view this content.

**mullock** · 02-12-2013, 01:08 PM

Sample.xlsm

You solved that!

Now I have a new problem

I am looping through columns and deleting selected ones. When I delete one the loop skips the next column I assume because the Shift left of the columns making my column number appear to be done already.

I tried to re-establish rw as "rw = rw - 1" but that screwed it all up.

Please Login or Register  to view this content.

Thanks again...

**patel45** · 02-12-2013, 02:14 PM

if you want delete rows you have to start the loop from the bottom, as this example

Please Login or Register  to view this content.

**mullock** · 02-12-2013, 02:26 PM

I am not deleting rows, I am deleting columns but that is not the problem, the problem is that when I delete the column, the loop in my example skips the next column because the Column numbers change.