Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
AutoFilter, Looping through the Rows? (Newbie)
Hi,
I've set an AutoFilter on Date and Company Name. COLUMNS: Date, Reference Number, Goods G-VAT, Cheque Number, Services S-VAT, New Balance, Previous Balance Company Name It selects 6 rows, as expected. I'm required to pre-process each row for certain column information, i.e. ignore Cheque Number and Previous Balance. How can I read into an array, a line at a time, and loop round all the selected Rows? Thanks in advance, Mark. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Looping a selection of rows | Excel Discussion (Misc queries) | |||
Looping through visible rows only | Excel Programming | |||
Looping through range newbie question | Excel Programming | |||
Looping through Ranges of Rows | Excel Programming | |||
Newbie : Autofilter thru code ? | Excel Programming |