+ Reply to Thread
Results 1 to 3 of 3

VBA To Count Cells Containing Bold Text

  1. 11-24-2023, 10:28 AM #1
    Tubtech
    Tubtech is offline
    Forum Contributor
    Join Date
    11-30-2020
    Location
    Ny
    MS-Off Ver
    Office 365
    Posts
    173

    VBA To Count Cells Containing Bold Text

    In the sample workbook provided is there a macro that will count the names in range F7:F12 that are in bold type and place the results in cell K12? thanks for the help!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 11-24-2023, 10:37 AM #2
    nankw83
    nankw83 is offline
    Forum Expert nankw83's Avatar
    Join Date
    08-31-2015
    Location
    Kuwait
    MS-Off Ver
    365
    Posts
    1,712

    Re: VBA To Count Cells Containing Bold Text

    Hi Tubtech,

    Try below code ...
    Please Login or Register  to view this content.
    Last edited by nankw83; 11-24-2023 at 10:42 AM. Reason: Code simplified
    If I was able to help, you can thank me by clicking the * Add Reputation under my user name
    Reply With QuoteRegister To Reply
  3. 11-24-2023, 04:02 PM #3
    Tubtech
    Tubtech is offline
    Forum Contributor
    Join Date
    11-30-2020
    Location
    Ny
    MS-Off Ver
    Office 365
    Posts
    173

    Re: VBA To Count Cells Containing Bold Text

    Thanks works like a charm !!!!
    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)

Similar Threads

  1. Delete all text which is not 'bold' in cells with 'mingled bold' text
    By Excelfriend in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-23-2010, 04:47 PM
  2. Count bold text values
    By Stan Altshuller in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-06-2005, 06:05 AM
  3. Count bold text values
    By Stan Altshuller in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  4. [SOLVED] Count bold text values
    By Stan Altshuller in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  5. [SOLVED] Count bold text values
    By Stan Altshuller in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-06-2005, 12:05 AM
  6. [SOLVED] Count bold text values
    By Stan Altshuller in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-05-2005, 11:05 PM
  7. Count Bold Text
    By CheekyChappy in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-11-2005, 07:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1