Posted by Josh on December 07, 2001 10:54 AM
I'm trying to write a VBA macro that copies data from CellA on Sheet1 to CellA on Sheet2. copying the data is not the hard part, it's not copying the cell formatting of CellA on Sheet1 that i'm having a problem with. so when i use my macro to copy the data over to Sheet2, it copies the border also. I thought that using
Application.CutCopyMode = False
would prevent the border from being copied over, but i guess i was wrong. MSDN website is no help either since it looks like they need to fix the type-o (see URL)
any other suggestions?