VBA - Centre all cells

[ChrisFoster]

Hi all,

Please could someone advise me what code I need in VBA to centre all cells (both horizontally and vertically) on an active worksheet?

Cheers

Chris

 

[RoryA]

Welcome to the forum.

Basically:

    With ActiveSheet.Cells
        .HorizontalAlignment = xlCenter
        .VerticalAlignment = xlCenter
    End With

 

[ChrisFoster]

Welcome to the forum.

Basically:

    With ActiveSheet.Cells
        .HorizontalAlignment = xlCenter
        .VerticalAlignment = xlCenter
    End With

Great, thank you.