Finding number of empty cells
All:
I read through numerous similar postings and stilll could not get my
simple UDF to work.
Function CountColumns(RngStartingPoint As Range) As Integer
CountColumns = Range(Cells(RngStartingPoint), Cells(1,
Cols.Count).End(xlToLeft))
End Function
I want to be able to count the number of blank cells from a given range
("AA1") back to a populated cell ("G1"). The populated cells contain
an "x".
Any assistance as to why this function is incorrect, would be greatly
appreciated.
Cheers.
|