Autofilter - Process Each Row

billgeo

New Member
Joined
Jul 29, 2014
Messages
18
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

New Member
Joined
Jul 29, 2014
Messages
18
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?
 
Last edited:

Some videos you may like

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,219
Office Version
  1. 365
Platform
  1. Windows
rngRow refers to each individual row as you go through the loop.

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

billgeo

New Member
Joined
Jul 29, 2014
Messages
18
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?
 

Watch MrExcel Video

Forum statistics

Threads
1,123,015
Messages
5,599,351
Members
414,306
Latest member
Dennis_vdw

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top