View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Floyd[_2_] Floyd[_2_] is offline
external usenet poster
 
Posts: 35
Default 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.