Hi, I've been trying to figure out how to use these suggestions, but none of
them work. I've put them as a cell formula, vba and functions but I always
get #value or #name or something. I know this is my error but I'm beyond
frustrated and can't figure out what I'm missing. Can someone please tell me
what I'm doing wrong, and exactly how these would get used?

lastRowNo = Range("A65536").End(xlUp).Row
Range("A2"),End(xlDown).Row if there are no blanks in the data,
otherwise
Cells(Rows.Count,"A").End(xlUp).Row