Copy without borders!!!!!!!!!

  • Thread starter Thread starter Syrus the Virus
  • Start date Start date
S

Syrus the Virus

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.
 
Ummmmmmm yeah I knew that I'm not as stupid as I look but How can I pu
that in VBA coding?????


Please help!!!
 
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)
 
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.aspx?scid=kb;EN-US;Q171281

XL97: Problems with Arguments of PasteSpecial Method (Q255520)
http://support.microsoft.com/default.aspx?scid=kb;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 said:
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)

message news:[email protected]...
Click to expand...
 
Back
Top