conditionally filling a VB array via excel

[them0use]

What I need is for upon a certain event, VB looks at excel and does:

For each row on the active worksheet
If ColumnA isn't empty
AND ColumnB is empty
Add CurrentRow# to the array.

So the function will return an array of integers, ie 3 6 8 where those are the row numbers.
Also this array then needs to be placed into a DropDownList,

Any help would be appreciated

[venkat1926]

quote
then needs to be placed into a DropDownList,
unquote
It is not clear what is meant by dropdown list. I assumed that you want the row numbers in a range in the same sheet.


Try this macro and the relevant row numbers will be in column E
the first row of data (col A and B) will have column headings.
that means data in these two columns start only from A2 B2

sample data given below

hdng1 hdng2
1 1
2
2
3 3
4 5
6
5
6 7
7 8
9
10

the macro is

Please Login or Register  to view this content.