Copying Cells Which Include Conditional Formatting in Worksheet
Sponsor
Excel Worksheet Copying Cells Which Include Formatting in Worksheet [Q]
I need some help modifying this microsoft excel code to include the worksheet formatting of the cell (conditional formatting):
If Not Intersect(Target, Range(”b4:b7″)) Is Nothing Then
Worksheets(”DuplicateSheet”).Range(”b11:b14″) =
Worksheets(”OriginalSheet”).Range(”b4:b7″).Value
End If
This is activated on the excel Worksheet_Change event. This excel code successfully copies that range of cells to the duplicate sheet should I make a change to one of them, but the conditional formatting is left behind. How can I drag the formatting over as well?
Thanks!
Excel Worksheet Copying Cells Which Include Formatting in Worksheet [A]
Your excel worksheet code is writen to transfer values only. I would suggest you use the copy this excel worksheet code :
If Not Intersect(Target, Range(”b4:b7″)) Is Nothing Then
Worksheets(”DuplicateSheet”).Range(”b11:b14″).Copy Destination:= _
Worksheets(”OriginalSheet”).Range(”b4:b7″)
End If
Rate This Tips:
(1 votes, average: 5.00 out of 5)
Loading ...Incoming excel search terms
copy conditional formatting to another sheet,simple vb code to copy cells from one worksheet to another worksheet,which include,excel makro copy format,copy formatting of a sheet to a new sheet using macro,copying cells,vba copy worksheet with formatting and formula,,cells worksheet,cells worksheets,conditional worksheets,conditionals worksheets,copy conditional formatting excel,copy dupplicates to another worksheet vba,copying cell conditional formatting of excel using vb net,copying cell from different sheet excel,copying conditional format across,copying conditional formatting in excel across multiple rows,copying formating,excel conditional formatting copying to another worksheet,excel macro copy destination delete conditional formatting,keep formatting when copying a worksheet in excel,macro keeping format multiple worksheets,macro to conditionally copy rows to another worksheet,= worksheet!cell,1h,average of two dates in excel conditional formatting,cell copy include cell name vba,change conditional formatting to code,code for copying sheets including formatting,code on copying cells,conditional copy cells in excel,conditional copy from one sheet to anothe sheet using macro,conditional format copy vb,conditional format with a macro vba less than a date,conditional formated cell in sheet,conditional formatting across a range of cells,conditional formatting across worksheets,conditional formatting all worksheets,conditional formatting copying,conditional formatting duplicate cells excel worksheets,conditional formatting duplicates different worksheet,conditional formatting duplicates in two worksheets,conditional formatting excel copy formatting,conditional formatting excel copying to a new worksheet,conditional formatting excel problems,conditional formatting excel vba,conditional formatting in excel across mutiply cells,conditional formatting in excel sheet based on one cell,conditional formatting multiple lines
Related Excel Tips
Comments
Have another excel answer or questions for this problem ?
Feel free to post it here..
Best Excel Tips
- Calling Macro Visual Basic Procedures of a Different Project (5.00 out of 5)
- Copy from Worksheet (5.00 out of 5)
- Change Worksheet Tab Colors (5.00 out of 5)
- Delete Worksheet (5.00 out of 5)
- Quick Way Determine The First and Last Business Day of the Month (5.00 out of 5)
- How to Calculate 6 Working Days Between Two Dates (5.00 out of 5)
- Date Calculation Start Date Minus Year, Month and Days (5.00 out of 5)
- Calling Macro Visual Basic Procedures of a Different Project
