Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Finding data amongst empty cells | Excel Discussion (Misc queries) | |||
Finding Empty Cells | Excel Programming | |||
Finding days between cells C and L where the cells may be empty | Excel Worksheet Functions | |||
finding/highlighting empty cells | Excel Programming | |||
Macro trouble finding 'empty' cells | Excel Programming |