Wolfy1S1308
New Member
- Joined
- Mar 6, 2022
- Messages
- 12
- Office Version
- 2010
- Platform
- Windows
I need to copy a range of cells C12:U21 from a sheet in another workbook. The other workbook has conditional formatting but when I copy, albeit successfully, there is no conditional formatting applied to 'ReportName'
Workbooks(xlsName).Worksheets("Main information").Range("C12:U21).Copy _ ------1
Workbooks(ReportName).Worksheets(TabName).Range("I3)
--------------------------------------------------------------------------------------
If I insert blank columns into 'xlsName' so that the data becomes I12:AA21
Workbooks(xlsName).Worksheets("Main information").Range("I12:AA21).Copy _ ------2
Workbooks(ReportName).Worksheets(TabName).Range("I3)
the conditional formatting is applied to 'ReportName
Is it possible to copy the conditional formatting as well as the data without requiring the insertion of columns into the data file 'xlsName'
Workbooks(xlsName).Worksheets("Main information").Range("C12:U21).Copy _ ------1
Workbooks(ReportName).Worksheets(TabName).Range("I3)
--------------------------------------------------------------------------------------
If I insert blank columns into 'xlsName' so that the data becomes I12:AA21
Workbooks(xlsName).Worksheets("Main information").Range("I12:AA21).Copy _ ------2
Workbooks(ReportName).Worksheets(TabName).Range("I3)
the conditional formatting is applied to 'ReportName
Is it possible to copy the conditional formatting as well as the data without requiring the insertion of columns into the data file 'xlsName'