What is the easiest way to copy a cell format (not values) to range of cells?

with VB of course.

Record a macro when you select your cell
edit|copy
then select the other range
edit|paste special|formats

And you'll see the code.

serdar wrote:
>
> with VB of course.

--

Dave Peterson

IMHO,

Use the "Format Painter".

You can also *double click* the icon, so as not to lose the copied format
between clicks on assorted cells and/or ranges.
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

"serdar" <[email protected]> wrote in message
news:[email protected]...
with VB of course.