Im looping thru a range using two variables that will transfer the outcome
to another sheet. I want to retrieve the cell value and the font format so it
carries any bolds. (No paste special...)

Variables-loop 1

NameLEG = Sheet1.Cells(RowLEG, 2) & " " & Sheet1.Cells(RowLEG, 3)
StreetLEG = Sheet1.Cells(RowLEG, 4)



Outcome-loop2
Worksheets("Labels").Cells(LastRowLabel, LastColLabel).Value = NameLEG
Worksheets("Labels").Cells(LastRowLabel + 1, LastColLabel).Value = StreetLEG

Thanks in advance