| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Addition function of multiple cells | Excel Discussion (Misc queries) | |||
| Logical function with multiple cells | Excel Worksheet Functions | |||
| Multiple cells for IF function | Excel Worksheet Functions | |||
| macro copy/paste data from multiple cells to multiple cells | Excel Discussion (Misc queries) | |||
| HOW TO EXEXUTE A FUNCTION FOR MULTIPLE CELLS | Excel Discussion (Misc queries) | |||
Linear Mode
