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

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
>
>

Cheers Gary''s Student.

All the Best.
Paul

On Aug 29, 10:22 am, Gary''s Student
<GarysStud...@discussions.microsoft.com> wrote:
> 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- Hide quoted text -
>
> - Show quoted text -