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




"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