+ Reply to Thread
Results 1 to 2 of 2

Maintain a BOLD font

Hybrid View

  1. 08-25-2007, 12:05 PM #1
    Martindelica
    Martindelica is offline
    Forum Contributor
    Join Date
    10-09-2006
    Posts
    212

    Maintain a BOLD font

    Hi there I need a formula that will keep the font even when i copy the contents of the cell and paste elsewhere.

    I have a table of data with number and some numbers are more inportant than others. I need to take the data and paste special "values" in order to sort them, but when I do this, the important numbers in BOLD come out normal. I have attached an eg.

    Kindest regards
    Martin.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 08-25-2007, 12:33 PM #2
    WinteE
    WinteE is offline
    Forum Contributor WinteE's Avatar
    Join Date
    04-07-2007
    Location
    Netherlands
    Posts
    544
    Hi Martin,

    It's not possible to copy only the Bold part of the font. What you could do is to copy all and after that you delete the borders. You can get the VBA code for this by using the macrorecorder.

    Erik
    Just keep it simple !


    http://www.excelguide.eu
    In English as well as in Dutch
    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