Format Range Block

[billandrew]

Afternoon

Trying hopelessly to format the first 3 cells in Column B Bold then the next 4 cells red so on...

Thank You

 

[cerfani]

just record yourself doing it and it will create the code, then you can edit the recorded code

i forget but it is something like... Range(...).Font.Bold = True

And Color is called InteriorColor iirc, also in the Font class iirc... just record it

 

[billandrew]

Despise recorder. lol

Thanks

 

[Norie]

billandrew

The macro recorder is a good way to get started with code.

Of course it's going to spew out a load of dross but it should at least give you something to work with even if it is the syntax to do what you want.

For what it's worth here's what I recorded when bolding the first 3 cells in B and coloring the next 4 red.

    Range("B1:B3").Select
    Selection.Font.Bold = True
    Range("B4:B7").Select
    With Selection.Interior
        .Pattern = xlSolid
        .PatternColorIndex = xlAutomatic
        .Color = 255
        .TintAndShade = 0
        .PatternTintAndShade = 0
    End With

 

[billandrew]

Looks like that would be an absolute range. My data continues for at the moment an undetermined amount of rows.

I should be able to adjust and add a loop of some sort.

Thank you appreciate your time.

 

[Norie]

Like I said, you'll get a load of dross, in this example Select/Selection etc., but you'll at least get the basic syntax needed.