+ Reply to Thread
Results 1 to 4 of 4

Macro to Copy BOLD Items

  1. #1
    Forum Contributor
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2021
    Posts
    2,725

    Macro to Copy BOLD Items

    I have tried to write code to Copy all Bold Items in Col B and paste these in Col D in the same row]

    When Running the code, the bold items in Col B isnot being pasted into Col D


    Please Login or Register  to view this content.


    It would be appreciated if someone could kindly amend my code
    Last edited by Howardc1001; 01-14-2022 at 12:13 AM.

  2. #2
    Forum Expert
    Join Date
    10-06-2017
    Location
    drevni ruchadlo
    MS-Off Ver
    old
    Posts
    2,151

    Re: Macro to Copy BOLD Items

    Show sample data in xls file - code works for all cell contents in 'Bold' (format), but will not work for partial contents in 'Bold' (format).
    What does it look like in your data ?

  3. #3
    Forum Contributor
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2021
    Posts
    2,725

    Re: Macro to Copy BOLD Items

    Sorry Forgot to attach File

  4. #4
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,528

    Re: Macro to Copy BOLD Items

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Find Bold items and copy in another sheet
    By srinivasan1965 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-23-2016, 05:20 AM
  2. Bold items in Userfrom ListBox
    By klonbeck in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-07-2013, 03:14 PM
  3. Replies: 5
    Last Post: 01-12-2012, 01:15 PM
  4. Format (bold, etc) concatenated items
    By erikilacad in forum Excel General
    Replies: 10
    Last Post: 12-27-2011, 01:51 PM
  5. Sum Bold Items Only
    By Snarf in forum Excel General
    Replies: 2
    Last Post: 06-17-2009, 03:44 PM
  6. List Box can you colour code items or make bold
    By christopher ward in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-10-2006, 07:55 PM
  7. How do I ask Excel to count how many items are in BOLD TYPE?
    By Head Honcho in forum Excel General
    Replies: 1
    Last Post: 08-04-2005, 08:05 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1