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
    Sub FillCellFromAbove()
    For Each cell In Selection
        If cell.Value = "" Then
            cell.Font.Bold = True
            cell.Value = cell.Offset(-1, 0).Value
        End If
    Next cell
    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:)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!