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
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