View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
[email protected] jmslab@xs4all.nl is offline
external usenet poster
 
Posts: 55
Default Select rows that are 'blinking'

Oke, some explanation.

The first module;
1) Active field is on or more cells. Those could be selected by the user in a range, but it could be also separated selected fields with the CTRL option.
2) The module looks for those active cells in column A and select all rows that have the same data in column A as the active cells in column A (info; Column A is allways sorted).
3) The module copied those records to another file/sheet (after first emptying those file/sheet) and fills in column X the data/time of the copy action, so the user can see that those ones are copied.

The second module;
This should be a follow up action of the first module.
If in the selection of bullit 3, in column L no data was registrated, then a message should popup with those information (= records xxx were empty).


regards, Johan (and thanks for helping me out !!)