Is there anyway to keep Cell format (aka: font/boardes/fillcolor) when
copying data from one Cell to another in VBA (macro) ?
Is there anyway to keep Cell format (aka: font/boardes/fillcolor) when
copying data from one Cell to another in VBA (macro) ?
if you copy and paste, then the format should be pasted as well.
--
Regards,
Tom Ogilvy
"-[::::Shamran::::]-" <[email protected]> wrote in message
news:[email protected]...
> Is there anyway to keep Cell format (aka: font/boardes/fillcolor) when
> copying data from one Cell to another in VBA (macro) ?
>
>
"Tom Ogilvy" <[email protected]> wrote in message
news:%[email protected]...
> 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::::]-" <[email protected]> wrote in message
news:[email protected]...
>
> "Tom Ogilvy" <[email protected]> wrote in message
> news:%[email protected]...
> > 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
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks