First visible cell row number to use in For-Next

[turist]

I have autofilter in Range D11:E11 and data goes down from D11:E11 to 50000th rows.

I use for all (generally )

Please Login or Register  to view this content.

code for-next statement.(İn this condition "12" is fixed)

But now when make autofilter for D11 (example for only 1 item) first visible cell comes as D135 and E135.

I want to use automatically 135as variable instead of fixed 12 in for i code.( This 135th row changes depending autofilter values)

How can I modify this For i code to use variable first visible cell row number?

Thanks in advance for any reply and help.

Regards,
turist

[JBeaucaire]

Try this:

Please Login or Register  to view this content.

[JBeaucaire]

If you want to ONLY cycle your loop through the VISIBLE filtered rows, switch from a LONG variable loop to a RANGE variable loop.

Please Login or Register  to view this content.

[turist]

Thanks all.
Worked very good.