getting last row of the filtered data

[welchs101]

I have this large file with yes and no in col A.

Run the macro below:

Please Login or Register  to view this content.

The last row reported is 224 when what i want is really 35. # of yes is 34 + col header.

any ideas?

[watersev]

hi, welchs101, hope this helps:

Please Login or Register  to view this content.

PS. Provided we are counting values in filtered range

[welchs101]

Thanks watersev. Your soln worked great. I also found another soln i am posting both. Took me a few hours to find the other soln on the net. Wish i had not wasted my time and just waited for your great soln.

Note: There are essentially two solns. and they are both at the end of the subroutine. THose marked as "row=34" are the correct soln.

Thanks again watersev!

Please Login or Register  to view this content.

[watersev]

if you are happy with the offered solution please mark the thread as solved (see Forum Rules on "How to" questions)

[welchs101]

fyi: i tried the new code (both possible solns) on some different code and ......well it did not work. So just be careful. I dont know why its not working yet but just double check you answers.

[watersev]

solutions are tailored to the specified parameters, if they are changed it might not work correctly. Please attach a sample workbook, I will look at it

[welchs101]

ok....it does work.......sorry for going back and forth. whats not working is my copy and paste of the data for some reason but the row count syntax does seem to work fine.

[watersev]

ok, pls ignore my PM to you if there are no outstanding issues.

[welchs101]

ok....just wanted to reaffirm.......the syntax does work.........my issue is now with copying filtered data. i was originally comparing the copy/pasted data with how much "should" be there and was finding that not all my data was transferred over. I thought i was due to the last row not being correct ..........the last row (using the new method discussed here for filtered data) is just fine........ the issue now is copying filtered data.......but i will save this for another thread.

thanks again.

[watersev]

well, in my judgement it is connected to the current thread, so if you do not mind, I will suggest to use this:

Please Login or Register  to view this content.

PS. Header can be copied separately:

Please Login or Register  to view this content.

[welchs101]

hi watersev,

i started another thread for this before i read your comment.

I had a quesiton: What dose the "offset(1)" do?