+ Reply to Thread
Results 1 to 4 of 4

Copy Function Options

  1. 04-15-2007, 05:07 AM #1
    jonn
    jonn is offline
    Forum Contributor
    Join Date
    11-17-2006
    Posts
    152

    Copy Function Options

    Hi,

    The normal .copy and .paste command just copy and paste the cell contents, how can i get them to also copy and paste the formatting i.e. the borders??


    Thanks
    Reply With QuoteRegister To Reply
  2. 04-15-2007, 05:23 AM #2
    davesexcel
    davesexcel is offline
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,482
    Hi,
    I am not sure what you mean,
    copy and paste copies the entire contents, then pastes the entire contents, unless you are using paste special
    ,
    Xlorate.com, Selection Codes, YouYube Channel
    Reply With QuoteRegister To Reply
  3. 04-15-2007, 07:57 AM #3
    jonn
    jonn is offline
    Forum Contributor
    Join Date
    11-17-2006
    Posts
    152
    yeah it copies and paste the contents but not the formatting i.e. it doesn't copy borders, text formatting etc
    Reply With QuoteRegister To Reply
  4. 04-15-2007, 08:23 AM #4
    davesexcel
    davesexcel is offline
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,482
    Quote Originally Posted by jonn
    yeah it copies and paste the contents but not the formatting i.e. it doesn't copy borders, text formatting etc
    Did you try paste special??
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1