Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
For Each with Hidden Rows
My worksheet has hidden rows. Which rows are hidden is
not known at run time. I want to do a For Each... loop that cycles through a range of cells in a column. However I've noticed that the loop ignores cells in hidden rows. Is there a way to cycle through a range that includes hidden rows? tod |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
For Each with Hidden Rows
Oops. It wasn't that the loop was skipping hidden rows.
It was that my statement for finding the last row was flawed. So as Emily Litella would say.... Never Mind -----Original Message----- My worksheet has hidden rows. Which rows are hidden is not known at run time. I want to do a For Each... loop that cycles through a range of cells in a column. However I've noticed that the loop ignores cells in hidden rows. Is there a way to cycle through a range that includes hidden rows? tod . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
For Each with Hidden Rows
Hi
post the code you have used :-) -- Regards Frank Kabel Frankfurt, Germany "Tod" schrieb im Newsbeitrag ... My worksheet has hidden rows. Which rows are hidden is not known at run time. I want to do a For Each... loop that cycles through a range of cells in a column. However I've noticed that the loop ignores cells in hidden rows. Is there a way to cycle through a range that includes hidden rows? tod |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
For Each with Hidden Rows
I can't duplicate your problem. If I hide 4 rows between 1 and 15, then run
the following code, 1 see all 15 row numbers. Ditto if the rows are hidden via AutoFilter. Can you post your code? for i = 1 to 15: debug.Print rows(i).row: next i for each r in range("A1:A15").rows: debug.Print r.row: next r On Tue, 26 Oct 2004 12:59:35 -0700, "Tod" wrote: My worksheet has hidden rows. Which rows are hidden is not known at run time. I want to do a For Each... loop that cycles through a range of cells in a column. However I've noticed that the loop ignores cells in hidden rows. Is there a way to cycle through a range that includes hidden rows? tod |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
opening a group but keep hidden rows hidden | Excel Discussion (Misc queries) | |||
Hidden rows columns won't stay hidden | Excel Worksheet Functions | |||
Formula or Code to keep Hidden Rows Hidden | Excel Worksheet Functions | |||
I need my Hidden Rows to stay hidden when I print the sheet. | Excel Discussion (Misc queries) | |||
Excel 2003 -Rows hidden. Scrolling unhides rows ! How do I stop th | Excel Discussion (Misc queries) |