Cut and Paste dark blue and red text

S

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.
 
D

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.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Moving data in Red and Dark Blue text. 4
Cut and Paste 4
cut/copy & paste w/source formatting except for conditional format 2
Paste failing after cut 7
Cut from one sheet, paste in another 3
IF value = "DEC" or "MAR" cut and paste 3 cells 3
Find, cut, and paste entire row 5
Cut and Paste Macro 1

Top