Copy a by macro special selected nr of rows into another file
Thanks !!
Almost as wished.
1.Heading
2.AAA
3.AAA
4.AAA
5.BBB
6.BBB
7.CCC
8.CCC
It works oke if you select only for example B3+B5+B7 (one record for each different data in column A). If you select more then one field and in those selected records the data in column A is registered in more then one situation, then you get the code error on; srcsht.Range(Mid$(working, 2)).EntireRow.Copy
So you can't select B3:B4 (because AAA is double in it).
You can't select B3:B7 (because AAA is double, even for BBB).
But so far so good. It's amazing how it works till now.
Perhaps a minor change to solve this issue.
thanks,
Regards.
|