Using a filtered range to calculate data, yet it goes through all the data.

[damngroundhog]

Hello

I am expanding my skills in VBA, and thanks to this forum i am really starting to enjoy automating my workbooks.

I had run into this problem earlier, and my workaround was "IF THEN" statements, primarily because the filtering aspect didn't work. But now, my datasets have become quite large and will continue to get larger.


I set my filters and all I am trying to do is go through each filtered line and add the word Yes to the 25th row. I am at a complete loss though as to why this won't work.

Please Login or Register  to view this content.

as you can imagine, this goes through all the cells.

Appreciate any guidance you can offer on this

Groundhog

[xladept]

Try:

Please Login or Register  to view this content.

[damngroundhog]

That was a typo, i meant to put in

Please Login or Register  to view this content.

And actually what happens is,

it counts the rows and puts them sequentially, so when i unfilter the sheet,

the first 250 items have yes in them

[xladept]

Maybe:

Please Login or Register  to view this content.

[damngroundhog]

That actually went through the entire worksheet plus 2000 more rows.

[xladept]

Another:

Please Login or Register  to view this content.