S -[::::Shamran::::]- Feb 27, 2005 #1 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) ?
S -[::::Shamran::::]- Feb 27, 2005 #3 Tom Ogilvy said: if you copy and paste, then the format should be pasted as well. Click to expand... 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
Tom Ogilvy said: if you copy and paste, then the format should be pasted as well. Click to expand... 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
T Tom Ogilvy Feb 27, 2005 #4 copy, then pastespecial and select xlValues. or pastespecial and select xlformulas -- Regards, Tom Ogilvy -[::::Shamran::::]- said: Tom Ogilvy said: if you copy and paste, then the format should be pasted as well. Click to expand... 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 Click to expand...
copy, then pastespecial and select xlValues. or pastespecial and select xlformulas -- Regards, Tom Ogilvy -[::::Shamran::::]- said: Tom Ogilvy said: if you copy and paste, then the format should be pasted as well. Click to expand... 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 Click to expand...
