|
|
#1
08-26-2015, 09:24 AM
|
|||
|
|||
Losing Conditional Formats Upon Macro Run
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?
|
|
#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
|
|
| Tags |
| conditional format, macro find and replace |
|
|
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 |
Windows XP 
Office 2003
Linear Mode
