Collecting names in database

[vin1]

Hi, I have a problem with finding a string value in my own created database.

I have to search every string that is attached to a paragraph

Please Login or Register  to view this content.

The names are in dutch but i think the idea is pretty simple, altough i cant figure out how i should do this.

If a Cell in Range Column A has "Vaste Activa" then Column B string on that row has to be added to array variable so it can be used.

tnxs in advance

[watersev]

hi, vin1, you can use autofilter on column A, criteria = "Vaste Activa" and take column B filtered results into array

[vin1]

The Actions that must be preformed are 100% VBA, no manual input. also i like to keep everything on the background. so no selection changes, Visual changes ect.

Else i whould try .Find(***).Offset(0, 1).Activate and loop this action. but so far i did not used anything that whould change selection, so i prefer to keep it that way.

It also avoids that the system wil malfunction and may cause wrong behaviour.

[vin1]

Up

still open

[watersev]

as an option

Please Login or Register  to view this content.

result data is in cell D4 and down