cut/copy & paste w/source formatting except for conditional format

J

Jamie

I regularly need to cut or copy and paste from one worksheet to another and
I'm having trouble with how I want it formatted.

ex:
T1234 22/07/09 SC 04/08/09 Norway
In my workbook T1234 has a blue fill (manual) and 04/08/09 has a green fill
(conditional formatting). I need to cut or copy and paste the entire row
into another worksheet and keep the blue formatting from the first cell, but
I don't want the conditional formatting anymore. Is there a way to do this
without changing the format every time after I paste? This would be
INCREDIBLY helpful! Thanks!
 
P

Per Jessen

Hi

When all data and formatting has been pasted, use the line below to
delete Conditional formatting from the range.

Range("A1:D10").FormatConditions.Delete 'Change range to suit

Hopes this helps.
....
Per
 
G

Gord Dibben

All I can think of is make the copy and paste then with the pasted cells
selected go to CF and "Delete"

All selected cells will have CF deleted.


Gord Dibben MS Excel MVP
 

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

Top