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.
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.
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).row
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
>
>
very nice. thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks