Return cell adress for next non-blank cell in a range

  • Thread starter Thread starter toreadore
  • Start date Start date
T

toreadore

Please help: How can i programmatically lookup the cell adress for nex
non-blank cell in a range?

Toreador
 
This UDF returns the cell address of the first non-blank cell in a range:

Function nonblank(R As Range) As String
Dim rr As Range
nonblank = ""
For Each rr In R
If IsEmpty(rr.Value) Then
Else
nonblank = rr.Address
Exit Function
End If
Next
End Function
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell adress for next non-blank cell in a range? 2
Search for specific text within last non blank cell in a range 2
VBA set thick borders around non empty cells in range 0
First Non-Blank Cell 6
Reference to next non-blank cell 5
Return Each Last Non-blank Cell, Value 2 Column Offset, Many GAPS 1
Letters with uniqe adress when printing 0
row number of last non-blank cell 14

Back
Top