VBA Macro Code To Select Every Row That is Bold in a Fixed Range

  • Hi

    I am using Macro to select all bold rows but once i run macro it selects every row, am i doing something wrong.

    If i remove formatting manually for entire page and make 1 or 2 rows bold it works.


    I do run 3 or 4 macros in total , and SelectBoldDesc Macro runs correctly until after I run a Macro to Insert Cell Data from rows Above and make them Bold.

    Please Help!!!


    This is the code im using to select only bold rows which only selects all rows!!!

    and this is the code i use to insert from lines above which causes the previous to selected everything


    Code
    1. Sub FillCellFromAbove()
    2. For Each cell In Selection
    3. If cell.Value = "" Then
    4. cell.Font.Bold = True
    5. cell.Value = cell.Offset(-1, 0).Value
    6. End If
    7. Next cell
    8. End Sub


    I would be very grateful for any assistance

  • Good to hear you have managed to solve your problem ...


    Thanks for sharing this with the Forum :)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)