Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Simple Count of certain cells | Excel Worksheet Functions | |||
Getting 2 different answers for simple count | Excel Worksheet Functions | |||
Simple problem, simple formula, no FUNCTION ! | Excel Worksheet Functions | |||
Simple count function | Excel Worksheet Functions | |||
simple count or sum function?? | Excel Programming |