Is there anyway to keep Cell format (aka: font/boardes/fillcolor) when
copying data from one Cell to another in VBA (macro) ?

"Tom Ogilvy" wrote in message
...
if you copy and paste, then the format should be pasted as well.


Yes exacly but i realy don't won't that to happen. Is there a way to change
the indiivdual formatting (color etc.) on celle through VBS/macro ?

Shamran

copy, then pastespecial and select xlValues.

or pastespecial and select xlformulas

--
Regards,
Tom Ogilvy

"-[::::Shamran::::]-" wrote in message
...

"Tom Ogilvy" wrote in message
...
if you copy and paste, then the format should be pasted as well.


Yes exacly but i realy don't won't that to happen. Is there a way to
change
the indiivdual formatting (color etc.) on celle through VBS/macro ?

Shamran