Finding first blank in column

[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

[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)

"famdamly" <famdamly.249k5e_1141674611.1245@excelforum-nospam.com> wrote in
message news:famdamly.249k5e_1141674611.1245@excelforum-nospam.com...
>
> 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
>