Copying from one sheet- Cell formating
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
|