I want to copy background color for example sheetA cell A1 to sheet B A1.
The cell A1 is using conditional formatting, I can copy simple but not with conditional formatting enabled.
Here is the code
Dim varTemp As Variant
varTemp = Worksheets("Summary").Range("F15:F21").Formula
Worksheets("People").Range("G3:G9").Copy
Worksheets("Summary").Range("F15:F21").PasteSpecial xlPasteAllMergingConditionalFormats
Worksheets("Summary").Range("F15:F21").Formula = varTemp
when I run the VB it just select the target cells and ask me to PASTE the results. So the bottom left status bar in 
Recent Questions...
ما را در سایت Recent Questions دنبال میکنید
برچسب:
نویسنده: استخدام کار
بازدید: 221
تاريخ: يکشنبه
6 تير
1395 ساعت: 14:40