How to align the text in center

Help Activities
1

I need to align a text in center in excel using vbscript

2

Hi @sruthesanju

Do you need to center align the particular cell or wholecolumn?

Regards

3

Particular cell

4

Hi @sruthesanju

You can try the below macro Code.

Sub travel()

Dim cells As Range

With Range("A3")

    .Merge
    .HorizontalAlignment = xlCenter
    .VerticalAlignment = xlCenter
End With
End Sub

Regards

5

Please check this video:

You can write your code then in this code for align. It is very simple to do that there.

6

Hi @sruthesanju

Have you tried the above vba?

Regards