Sounds simple, but...
I have a sheet with 11 columns of data.
Each row is formatted according to values in certain columns (e.g. if person is project leader = Fat text, has left the project = red background) etc.
Now I want to copy some cells (No problem here thanks to people on here) and paste these in a new sheet, keeping the "aesthetics" and values, but leaving the automatic formatting behind. I.e. red text remains red, blue background remains blue, but cells are "detached" from the automatic formatting in the original sheet.
Is this possible?
Right now I paste as a picture using:
Which works in Excel "visually" but causes problems later (e.g. when printing as PDF)
I have a sheet with 11 columns of data.
Each row is formatted according to values in certain columns (e.g. if person is project leader = Fat text, has left the project = red background) etc.
Now I want to copy some cells (No problem here thanks to people on here) and paste these in a new sheet, keeping the "aesthetics" and values, but leaving the automatic formatting behind. I.e. red text remains red, blue background remains blue, but cells are "detached" from the automatic formatting in the original sheet.
Is this possible?
Right now I paste as a picture using:
Code:
Selection.SpecialCells(xlCellTypeVisible).Copy
Sheets("shttemp").Select
Range("A1").Select
ActiveSheet.Pictures.Paste.SelectWhich works in Excel "visually" but causes problems later (e.g. when printing as PDF)
