View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Barton[_2_] Barton[_2_] is offline
external usenet poster
 
Posts: 2
Default 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.