VBA How to copy the content of a cell without .Select
Worksheets("Get Address").Range("A33").Copy _
Destination := Worksheets("Label").Range("A1")
to copy and paste values only then use following
Worksheets("Label").Range("A1").value = _
Worksheets("Get Address").Range("A33").value
this statement will not use clip board