Hide value from cell when printing

[ipbr21054]

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.

Sheets("Sheet1").Range("E6:J6").Copy Sheets("PRINT LABELS").Range("E5")
Sheets("Sheet1").Range("E7").Copy Sheets("PRINT LABELS").Range("E6")

 

[ipbr21054]

This works for me but after Activate do i need to specify Sheets("PRINT LABELS") again ?

Sheets("Sheet1").Range("E6:J6").Copy Sheets("PRINT LABELS").Range("E5")
Sheets("Sheet1").Range("E7").Copy
Sheets("PRINT LABELS").Activate
Sheets("PRINT LABELS").Range("E6").PasteSpecial Paste:=xlPasteValues

 

[HaHoBe]

Hi,

why not use

Sheets("PRINT LABELS").Range("E6").Value = Sheets("Sheet1").Range("E7").Value

Or set the NumberFormat to not show the contents and set back after print like

    Range("E6").NumberFormat = ";;;"
    'Print
    Range("E6").NumberFormat = "General"

Ciao,
Holger

 

[ipbr21054]

Thanks for that, i think i was thinking to hard.
I used the below.

Sheets("PRINT LABELS").Range("E6").Value = Sheets("Sheet1").Range("E7").Value