Count filtered rows with no value

[ernief]

Hi
I have a spreadsheet which reduces in two hits and I display the last filtered list in a listbox. I am using the following code to count the rows from the bottom u[, but as there is formula in the cells it stops at the first cell with a formula even if the value is nil or blank.

RecordCount = wsOpenIssues.Range("AT3", wsOpenIssues.Range("AT1048576").End(xlUp)).Rows.Count

Is there another way to locate the last cell with a value in it
Thanks
ernief

 

[Sektor]

You want to know the count of filtered range?

 

[ernief]

You want to know the count of filtered range?

Yes and I want to restrict the listbox to the number of rows with values in the first column

 

[ernief]

Yes and I want to restrict the listbox to the number of rows with values in the first column

Also I should have said I am getting blank rows in the list box after the rows with values because the first column has a formula which is returning blank data due to the filter process. So I am trying to restrict the listbox to show only those rows where the formula has provided a value.