Finding first blank in column

F

famdamly

I'm trying to have the row number of the first blank cell in a column on
another sheet become the value of cell w11 on sheet1

It's in a macro ran by a button.

Here's what I have but it's not working

Worksheets("sheet1").Range("W11").Value =InfoList! COUNTA(a:a)+1
 
B

Bob Phillips

Worksheets("sheet1").Range("W11").Value
=Worksheets("InfoList").Range("A1").End(xlDown).Row +1

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Top