Simple center ? VBA

[zone709]

Hi simple ? need to center first row from A1 to G1

[LEFT][COLOR=#333333][FONT=monospace].Columns("A1:G1").HorizontalAlignment = xlCenter[/FONT][/COLOR][/LEFT]

don't work​

.Columns("A:G").HorizontalAlignment = xlCenter

works but centers everything from A to G

Thanks
​

 

[mumps]

Try:

Range("A1:G1").HorizontalAlignment = xlCenter

 

[Rick Rothstein]

Hi simple ? need to center first row from A1 to G1

.[B][COLOR="#FF0000"]Columns[/COLOR][/B]("A1:G1").HorizontalAlignment = xlCenter[/FONT][/COLOR][/LEFT]

don't work​

​

A1:G1 is a range, not a set of columns... try changing the keyword Columns that I highlighted in red to the keyword Range instead.​

 

[zone709]

Dam it should of none. Why I come here sometimes I was trying it over and over with Columns. Thanks guys