software

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(quot;sheet1quot;).Range(quot;W11quot;).Value =InfoList! COUNTA(a:a) 1--
famdamly
------------------------------------------------------------------------
famdamly's Profile: www.excelforum.com/member.php...oamp;userid=29382
View this thread: www.excelforum.com/showthread...hreadid=519467Worksheets(quot;sheet1quot;).Range(quot;W11quot;).Value
=Worksheets(quot;InfoListquot;).Range(quot;A1quot;).End(xlDown).Ro w 1

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;famdamlyquot; gt; wrote in
message ...
gt;
gt; I'm trying to have the row number of the first blank cell in a column on
gt; another sheet become the value of cell w11 on sheet1
gt;
gt; It's in a macro ran by a button.
gt;
gt; Here's what I have but it's not working
gt;
gt; Worksheets(quot;sheet1quot;).Range(quot;W11quot;).Value =InfoList! COUNTA(a:a) 1
gt;
gt;
gt; --
gt; famdamly
gt; ------------------------------------------------------------------------
gt; famdamly's Profile:
www.excelforum.com/member.php...oamp;userid=29382
gt; View this thread: www.excelforum.com/showthread...hreadid=519467
gt;