Losing Conditional Formats Upon Macro Run

Phil H · #1 08-26-2015, 09:24 AM

Conditional formats apply to column A. Also have a macro copying from cells in column E to Column A. When macro is executed, all conditional formats are deleted. Is there a way to protect CFs?

gebobs · #2 08-26-2015, 09:59 AM

Can you have your macro only paste values?

Phil H · #3 08-26-2015, 10:03 AM

Don't understand your question - only paste values.

gebobs · #4 08-26-2015, 01:32 PM

When you paste in Excel, you are not just pasting the values. By default, you are also pasting formulas, formatting, comments, and any data validation of the cell(s) that you copied.

If you only wants to paste one of those and not the others, you use Paste Special. I use it all the time when I want to copy the value of a cell that has a formula to another cell.

Same thing in macros. You need to use a PasteSpecial VBA command and it looks something like this...

Code:

wb.Sheets(1).Range("A1").PasteSpecial Paste:=xlPasteValues

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional Formatting Macro	grexcelman	Excel Programming	1	01-10-2015 04:45 PM
Conditional Formatting and/or Macro for Character Insertion?	MonOverArchIng	Word	2	01-11-2013 02:48 AM
TOC formats	ruggb	Word	3	03-09-2012 02:07 AM
Macro that formats Skype IMs	Alonso	Word VBA	5	01-02-2012 06:53 PM
Macro for different file formats	pengyou	Office	0	04-06-2010 09:27 PM