خرید بک لینک

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 video

برچسب: نویسنده: استخدام کار تاريخ: يکشنبه 6 تير 1395 ساعت: 14:40

صفحه بندی