Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy without borders!!!!!!!!!
Guys and galls,
I need help. How can I copy cells from one sheet with borders to another sheet only then without borders!!!!!! Please Help. --- Message posted from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy without borders!!!!!!!!!
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy without borders!!!!!!!!!
Ummmmmmm yeah I knew that I'm not as stupid as I look but How can I pu
that in VBA coding????? Please help!!! -- Message posted from http://www.ExcelForum.com |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy without borders!!!!!!!!!
Run it through the macro recorder. It shouldn't take long.
-- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Syrus the Virus " wrote in message ... Ummmmmmm yeah I knew that I'm not as stupid as I look but How can I put that in VBA coding????? Please help!!!! --- Message posted from http://www.ExcelForum.com/ |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy without borders!!!!!!!!!
There is a known bug in XL97 and XL2K regarding PasteSpecial of Validation
and AllExceptBorders. Refer to the following MS Knowledge Base articles: XL97: Problems with Arguments of PasteSpecial Method (Q171281) http://support.microsoft.com/default...;EN-US;Q171281 XL97: Problems with Arguments of PasteSpecial Method (Q255520) http://support.microsoft.com/default...;EN-US;Q255520 My preferred workaround is to declare the enum's as public: Const xlPasteValidation = 6 Const xlPasteAllExceptBorders = 7 Hope this helps James dot Becker at NCR dot com -- ~ ~ ~ :wq! "Bob Phillips" wrote in message ... Run it through the macro recorder. It shouldn't take long. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Syrus the Virus " wrote in message ... Ummmmmmm yeah I knew that I'm not as stupid as I look but How can I put that in VBA coding????? Please help!!!! --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I copy borders without erasing other destination formats? | Excel Discussion (Misc queries) | |||
Losing cell borders when I copy and paste | New Users to Excel | |||
Copy&paste cells w/o affecting borders | Excel Discussion (Misc queries) | |||
Preserve borders during copy and paste? | Excel Discussion (Misc queries) | |||
borders | Excel Discussion (Misc queries) |