Cells.Font.Name = "Tahoma"
--
Gary''s Student - gsnu200740


"Paul Black" wrote:

Hi everyone,

I have a sheet named "Stats" that I want to delete and then add a
sheet named "Stats" (the same name) which is what ...

Worksheets("Stats").Delete
Worksheets.Add.Name = "Stats"

.... the above does.
What I would also like to do is to Format the WHOLE sheet as Tahoma
Font please.

Thanks in Advance.
All the Best.
Paul