Multiple cells in cells function
 

I want to center a few cells, but my sytax is not correct with the cells
function. Here is what I have. Thanks for the help

cells(3,columnnum:columnnum+2).HorizontalAlignment = xlCenterAcrossSelection

I cannot use the range funtion since my row value is a variable.

Multiple cells in cells function
 

You can use the Range function try this...

Range(cells(3, columnnum), cells(3, columnnum +2)).HorizontalAlignment =
xlCenterAcrossSelection

HTH.

"Adam" wrote:

I want to center a few cells, but my sytax is not correct with the cells
function. Here is what I have. Thanks for the help

cells(3,columnnum:columnnum+2).HorizontalAlignment = xlCenterAcrossSelection

I cannot use the range funtion since my row value is a variable.