Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need some help with the following: I have a (dynamic) range called
rangetest. I want to show some data in a userform, with buttons "next" and "previous". But I don't now how to count the rows in my range (see the code below). Any help would be appriciated!! i = rangetest + 1 vrijwap.Caption = Cells(i, 5).Value vrijwuw.Caption = Cells(i, 6).Value vrijwwj.Caption = Cells(i, 7).Value profap.Caption = Cells(i, 8).Value profuw.Caption = Cells(i, 9).Value profwj.Caption = Cells(i, 10).Value next.Enabled = i < swapalles.Rows.Count / ListCount - wrong!! previous.Enabled = i 1 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Counting number of rows between date range and meeting 2 string criteria | Excel Worksheet Functions | |||
Counting Rows Then Counting Values in Columns | Excel Programming | |||
Counting Variable Length of Rows in a Named Range | Excel Programming | |||
Counting Variable Length of Rows in a Named Range | Excel Programming | |||
Counting Variable Length of Rows in a Named Range | Excel Programming |