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.
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.
Maybe this :
Please Login or Register to view this content.
GC Excel
If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.
Nope. Here is an example of the file that I want to use. Returned values in column B.
Much better when we can see the file. Macro is totally different.
Try this instead :
Please Login or Register to view this content.
This works perfectly. Can you explain what each piece is doing? Thanks.
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.
Here's a version with one loop.
Please Login or Register to view this content.
If posting code please use code tags, see here.
I tried this code with this format and it didn't work. Why? Spreadsheet attached.
Which code are you referring to and how did it not work?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks