Double 'For Each Cell' loop range problem

**gombi** · 06-20-2014, 12:28 PM

Hi all,

I’m doing a ‘for loop’ within a ‘for loop’ and the range does not change. I can’t figure out why.

I need the variable ColumnB to give me the addresses of column B, but it returns $A$1 and so on.

Thanks for an advice.

Please Login or Register  to view this content.

**Mad-Mizer** · 06-20-2014, 12:42 PM

Hi gombi,

Declaring variables will be very helpful as you learn how to code VBA. If you need to know about variable types, I suggest you Google VBA Variable types. As for the code itself, let me know if mine covers what you want. If yes, compare it to yours and think about the differences.

Please Login or Register  to view this content.

**Norie** · 06-20-2014, 12:48 PM

Try changinging Cell to Cell1 in the inner loop.

Mind you I'm not sure you need 2 loops.

**gombi** · 06-20-2014, 02:25 PM

Try changinging Cell to Cell1 in the inner loop.

Thanks a lot! That fixed my issue! :-)

Double 'For Each Cell' loop range problem

LinkBack

Thread Tools

Rate This Thread

Display

Double 'For Each Cell' loop range problem

Re: Double 'For Each Cell' loop range problem

Re: Double 'For Each Cell' loop range problem

Re: Double 'For Each Cell' loop range problem

Thread Information

Users Browsing this Thread

Similar Threads

Vlookup problem in a loop with cell property and variable cell problem (long title sry)

Problem using loop for sending excel range in email body using Range to HTML code

Loop and range problem

.Find problem when the found range's rows go from single to double digits

problem with Range statement in With-End With loop

Bookmarks

Bookmarks

Posting Permissions