VBA code to read last filled row of data column, works, but doesnt work

I'm trying to figure out the issue with my code. I have a spreadsheet where I'd like to run a macro. The number of rows changes constantly as every workbook I'll be working with has a different number of rows.
I'm basically trying to get my VBA code to read the last row of a column that has been filtered out. When the filter is applied it will fill column B with a value of N. My current code works, however, at the end of the table, I'm getting 4 additional "N" values outside the table range or rows. I debug each step and I believe the code

Please Login or Register  to view this content.

is causing the issue.
I currently have this code:

I was able to get it to read the number of rows existing in the workbook:

Please Login or Register  to view this content.

However, at the end of the table, there are additional N values outside the table itself. I did a debug and I believe its the part highlighted in red that's giving me problems, especially the "1r". I attached a copy of a screenshot to show you what I'm talking about.

How can I fix this? You'll see that there are 4 "N"s on the left side below the table.

Is this solved?

If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.