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)
 

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

Top