Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
For Loop in Filtered List
How do I structure a 'for loop' within a filtered list?
I keep the header row blank, and I want to start from the second row that contains data (not the first) ++++(*) represents the column letter+++++ for each CELL in FILTERED_LIST set cell.column(4).formulalocal = "=EXACT(N" & PREV_CELL.row & ",N" & CURR_CELL.row & ")" next The BLOCK letters are what I don't know. When I say PREV_CELL, I mean the previously visible cell. I've tried to use the constant XlCellTypeVisible, but that didn't do much TIA Hafeez Esmail |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Loop through drop down list | Excel Worksheet Functions | |||
loop a list with the IF formula | Excel Discussion (Misc queries) | |||
Loop through varible list of sheets | Excel Discussion (Misc queries) | |||
LOOP - Adddress List -to email | Excel Discussion (Misc queries) | |||
loop thru auto-filtered list | Excel Programming |