ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,224
- Office Version
- 2007
- Platform
- Windows
Happy New Year.
My goal is that i would like to have a value not shown in a specific cell & also with no borders etc for when i print.
The line of code supplied below is the issue i believe.
On Sheet1 i have values in cells which have black fonts & borders
These values are then copied & pasted to the worksheet PRINT LABELS
My problem is only cell E6 when pasted.
I have the PRINT LABLES worksheet cell E6 set as white font with no borders but when pasted its ignored each time.
It takes onboard the borders & font color from where it was copied.
My goal is that i would like to have a value not shown in a specific cell & also with no borders etc for when i print.
The line of code supplied below is the issue i believe.
On Sheet1 i have values in cells which have black fonts & borders
These values are then copied & pasted to the worksheet PRINT LABELS
My problem is only cell E6 when pasted.
I have the PRINT LABLES worksheet cell E6 set as white font with no borders but when pasted its ignored each time.
It takes onboard the borders & font color from where it was copied.
Rich (BB code):
Sheets("Sheet1").Range("E6:J6").Copy Sheets("PRINT LABELS").Range("E5")
Sheets("Sheet1").Range("E7").Copy Sheets("PRINT LABELS").Range("E6")