I don't see any code, but you can add text to a cell and change the font with something like:

ActiveCell.Value = "Less Trade In"
With ActiveCell.Font
.Name = "Times New Roman"
.Size = 10
End With

--

John Green - Excel MVP
Sydney
Australia


"gav meredith" wrote in message ...
Hi,

With the following code, how would i amend it to insert text "Less Trade
In'? Can i adjust the font??

Thank you!!