Oeps..... misstake by me. Sorry !!!!.
Copied the macro in the wrong part of my total process.
It works just as I asked. Great !! Thanks. !!!!!!

Perhaps you can help me out with a (minor?)change.

The macro works now on one selected field and it looks now in column A if there is the same data in it in the nearby records. When the data in column A is the same in several records the macro select all this records for copying.

Is it possible to combine this macro with an option that if you selected more then one datafield (for example B4:B10) that the macro looks also to column A but now there is the possiblity that there is not only AAA filled in, but also in some records BBB. Then the macro has to select also all the AAA records but also together the BBB records (so.... there could be more then one unique value in column A).

De rest of the macro keeps the same - copy to another file.

regards,
Johan