Hi, I have defined left border for cells in the column B. However, when I paste data over two columns (B, C), the border is overwritten. Any way to prevent this from hapenning?
Not looking for work around such as creating micro column on the right to B column or special pasting of values.
Use Paste Special | Values or Paste Special | Formulas, depending on the content of the cell, rather than just Paste.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks