Simple Count problem
 

Obviously new to VBA.

I want to run a while function depending on the number of rows on
second sheet. ex..

a = 1
While a <= Sheet(2).rows.count
a = a + 1
...
this doesn't work. Any help. Thanks much

--
Paul98
-----------------------------------------------------------------------
Paul987's Profile: http://www.excelforum.com/member.php...fo&userid=2485
View this thread: http://www.excelforum.com/showthread.php?threadid=51735

Simple Count problem
 

One way:

This will loop through all rows based on row count of column A and assumes
row 1 is a header; adjust starting value of r (=2) and column as required.

Dim lastrow as Long, r as long

lastrow=Sheet(2).Cells(rows.count,"A").end(xlup).r ow
For r=2 to lastrow
.......

Next r

HTH

"Paul987" wrote:


Obviously new to VBA.

I want to run a while function depending on the number of rows on a
second sheet. ex..

a = 1
While a <= Sheet(2).rows.count
a = a + 1
...
this doesn't work. Any help. Thanks much.


--
Paul987
------------------------------------------------------------------------
Paul987's Profile: http://www.excelforum.com/member.php...o&userid=24850
View this thread: http://www.excelforum.com/showthread...hreadid=517357

Simple Count problem
 

very nice. thank you.


--
Paul987
------------------------------------------------------------------------
Paul987's Profile: http://www.excelforum.com/member.php...o&userid=24850
View this thread: http://www.excelforum.com/showthread...hreadid=517357