Finding first blank in column
 

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


--
famdamly
------------------------------------------------------------------------
famdamly's Profile: http://www.excelforum.com/member.php...o&userid=29382
View this thread: http://www.excelforum.com/showthread...hreadid=519467

Finding first blank in column
 

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"famdamly" wrote in
message ...

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


--
famdamly
------------------------------------------------------------------------
famdamly's Profile:
http://www.excelforum.com/member.php...o&userid=29382
View this thread: http://www.excelforum.com/showthread...hreadid=519467