Autofilter - Process Each Row

[billgeo]

I want to do what seems to me a simple process to autofilter my sheet on a column and the process each filtered row in some manner.
I've tried and tried well over a dozen different ways found on Google and here using AutoFilter but they always result in some error. At this point I can't explain each error as there have been so many different ones. Maybe someone can post a simple general macro to do such.
Here is a basic example of what I'm looking for:
* A sheet with 20 rows and 6 columns of data
* The header row is row 3 (data in rows 4-20)
* I want to filter the sheet on column 1 = 100
* Then I want to process each displayed row using data in the displayed row.

Note: I'll be looping this process through several re-autofilers on column 1. My actually sheets has several thousand rows

Thanks for ANY insights!! as I'm going nuts not being able to get this simple idea to work.

Bill

 

[billgeo]

Hmmmm. I guess I have to ask then... How do I access the data in each visible row under the
For Each rngRow In rngArea.Rows
?

Do I need to retrieve the address of each row then access the row via that address?

 

[Norie]

rngRow refers to each individual row as you go through the loop.

To refer to values in the row use Cells(1, <colno>)

 

[billgeo]

Interesting. That did it. But it didn't seem logical to me at first but tried it. After seeing it worked I was able to twist my mind enough to see why it did.

THANKS!!

ps. is there a means to give you credit for solving my issue?