I want Sheets 2 & 3 to use Arial size 8 formatting only. What's the
best way to do that?


Thanks in advance,
-- Dan

Thanks galimi, it worked perfectly.

-- Dan

galimi wrote:
> Dan,
>
> You can write the following for the sheet2 object to change the current used
> range. If you want to apply it to the whole sheet, use cells instead of
> usedrange.
>
> with sheet2.usedrange.font
> .name = "Verdana"
> .size=8
> end with
> --
> http://HelpExcel.com
> (E-Mail Removed)
>
>
>
> "Dan R." wrote:
>
> > I want Sheets 2 & 3 to use Arial size 8 formatting only. What's the
> > best way to do that?
> >
> >
> > Thanks in advance,
> > -- Dan
> >
> >