Cut and Paste dark blue and red text

[SiH23]

I need a macro that will cut and paste all values in dark blue and red text
over to a new worksheet in the workbook (or basically any text that is not
black).

The first row of data starts at row 9 and finishes at row 9116.

Any help or advice would be greatly appreciated.

Regards,

Simon.

 

[Dave Peterson]

You have an active thread elsewhere.

I need a macro that will cut and paste all values in dark blue and red text
over to a new worksheet in the workbook (or basically any text that is not
black).

The first row of data starts at row 9 and finishes at row 9116.

Any help or advice would be greatly appreciated.

Regards,

Simon.