Search for First Blank in Column

[KORKIS2]

I need to find the length of Column K to the First blank in the Column
Then store row # in a variable

 

[bbott]

Try this array formula (CTRL+SHIFT+ENTER, not just Enter):

=MATCH(TRUE,K:K="",0)

Excel will surround your array formula with {} when entered correctly.

 

[KORKIS2]

I really appreciate your help I need it in macro form though sorry I didn't specify I have to add it to awhole bunch of other code.

 

[bbott]

Someone else can probably write you something more efficient but this should work.

Sub FindLastK()
    
    Dim x As Long
    Dim y As Long
    
    For x = 1 To Range("K" & Rows.Count).End(xlUp).Row
        If Range("K" & x) = "" Then
            y = Range("K" & x).Row
            Exit For
        End If
    Next x
    
    MsgBox (y)
    
End Sub

 

[KORKIS2]

I appreciate it, it keeps pulling up 0 though

 

[bbott]

When you said "first blank cell", I assumed that there was a break in the data in column K. If you just want to find the last row of data, try:

Sub FindK()
    
    Dim x As Long
    
    x = Range("K" & Rows.Count).End(xlUp).Row
    MsgBox (x)
    
End Sub

 

[KORKIS2]

Thank you very much I appreciate your time

 

[bbott]

Thank you very much I appreciate your time

You're welcome.