Sometimes, the easiest thing to do is to record a macro when you do it manually.

You'll get exactly the font size, name, and text color you want to use.

Kamyk wrote:

Hello all!

I have a problem I cannot get out of.
I would like to ask you how to do in visual basic the following things:
- change a border line - bold and the other possibilities
- change the font size and font name, the text color

This is easy question but I don`t know how to do it.
Thank you in advance
Marcin from Poland

--

Dave Peterson