create a for loop within a for loop

**ammartino44** · 06-01-2015, 04:35 PM

I created this loop below. Now I need to add code that will divide Range ("C" & i) by the closest cell (going down, not up) with formatting that has an upper line border. How can I add this?

Please Login or Register  to view this content.

**GC Excel** · 06-01-2015, 05:00 PM

Maybe this :

Please Login or Register  to view this content.

**ammartino44** · 06-01-2015, 06:43 PM

Nope. Here is an example of the file that I want to use. Returned values in column B.

**GC Excel** · 06-01-2015, 07:23 PM

Much better when we can see the file. Macro is totally different.
Try this instead :

Please Login or Register  to view this content.

**ammartino44** · 06-01-2015, 07:49 PM

This works perfectly. Can you explain what each piece is doing? Thanks.

**GC Excel** · 06-01-2015, 08:15 PM

It finds all areas separated by a blank row and the adds the formula.
I've added some comments in the code.
If you need more help, try using the F1 key (help) on the keywords such as .Address, .SpecialCells, etc...

Please Login or Register  to view this content.

**Norie** · 06-01-2015, 08:33 PM

Here's a version with one loop.

Please Login or Register  to view this content.

**ammartino44** · 06-02-2015, 01:43 PM

I tried this code with this format and it didn't work. Why? Spreadsheet attached.

**Norie** · 06-02-2015, 02:28 PM

Which code are you referring to and how did it not work?

create a for loop within a for loop

LinkBack

Thread Tools

Rate This Thread

Display

create a for loop within a for loop

Re: create a for loop within a for loop

Re: create a for loop within a for loop

Re: create a for loop within a for loop

Re: create a for loop within a for loop

Re: create a for loop within a for loop

Re: create a for loop within a for loop

Re: create a for loop within a for loop

Re: create a for loop within a for loop

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] I want to create loop with a loop

Loop through multiple files and call macros (but unable to loop)

[SOLVED] Copy dynamically changing column and Paste using VBA Loop (Loop within Loop)

Why did an inner loop variable start overwriting the outer loop range suddenly?

How do I create a For loop within a For loop?

Bookmarks

Bookmarks

Posting Permissions