View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default Copy Formatting of Cell

Hi
if you want to copy the formats for many cells you may have a look at
'Edit - Paste Special - Formats'. If this is not what you're looking
for you may explain with some more detail how you ant to copy and if
this is a one-time operation of if you want to change the formats
automatically if the source formats changes

--
Regards
Frank Kabel
Frankfurt, Germany

"WintonCW" schrieb im Newsbeitrag
...
All right -- any suggestions for what to do? I'm pretty hesitant to

copy each cell's characteristic individually as this is a sizeable --
and variable -- sheet.

Thank you