Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Looping in VB with cell ranges
I have a function that brings in four different cell ranges:
ie: Total(AccountRange As Range, DateRange As Range, etc...) Within the VB function I have a For/Next Loop as follows: ie: For Each cell in AccountRange "multiple if statements" Next cell I want to increment the rows in the other cell ranges during the looping process. When the AccountRange row increases during the "Next cell" call then I want the other ranges to follow suit. By the way what actually happens during the looping process for a range of cells? If the range is 2 columns by 4 rows does the "Next cell" call go down the rows then jump to the top of the 2nd column and again proceed down the rows?? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Looping in VB with cell ranges
"Freeman" wrote in message ... I have a function that brings in four different cell ranges: ie: Total(AccountRange As Range, DateRange As Range, etc...) Within the VB function I have a For/Next Loop as follows: ie: For Each cell in AccountRange "multiple if statements" Next cell I want to increment the rows in the other cell ranges during the looping process. When the AccountRange row increases during the "Next cell" call then I want the other ranges to follow suit. What exactly do you mean? You can get the row by simply using cell.Row but I am not clear as to what you mane by increment the rows in the other cell ranges. By the way what actually happens during the looping process for a range of cells? If the range is 2 columns by 4 rows does the "Next cell" call go down the rows then jump to the top of the 2nd column and again proceed down the rows?? No, other way. It goes across the columns, then down to the first column of the next row. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Looping in VB with cell ranges
BTW, you can force it down the rows, then next column with
For Each cell in Application.Transpose(rng) but you are not working with a range object now, but an array of values. -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Freeman" wrote in message ... I have a function that brings in four different cell ranges: ie: Total(AccountRange As Range, DateRange As Range, etc...) Within the VB function I have a For/Next Loop as follows: ie: For Each cell in AccountRange "multiple if statements" Next cell I want to increment the rows in the other cell ranges during the looping process. When the AccountRange row increases during the "Next cell" call then I want the other ranges to follow suit. By the way what actually happens during the looping process for a range of cells? If the range is 2 columns by 4 rows does the "Next cell" call go down the rows then jump to the top of the 2nd column and again proceed down the rows?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
Transfer Cell Formatting for linked cells | Excel Discussion (Misc queries) | |||
How cell ranges are handled by worksheet functions/row column matc | Excel Worksheet Functions | |||
copying cell names | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions |