G Guest Nov 10, 2003 #1 How we can set the align text properties of a cell or range of cells through macro
N Nikos Yannacopoulos Nov 10, 2003 #2 Selection.HorizontalAlignment = xlCenter Selection.HorizontalAlignment = xlLeft Selection.HorizontalAlignment = xlRight Selection.HorizontalAlignment = xlCenter Selection.HorizontalAlignment = xlCenterAcrossSelection Selection.VerticalAlignment = xlCenter Selection.VerticalAlignment = xlTop Selection.VerticalAlignment = xlBottom Nikos Y. (nyannaco at in dot gr)
Selection.HorizontalAlignment = xlCenter Selection.HorizontalAlignment = xlLeft Selection.HorizontalAlignment = xlRight Selection.HorizontalAlignment = xlCenter Selection.HorizontalAlignment = xlCenterAcrossSelection Selection.VerticalAlignment = xlCenter Selection.VerticalAlignment = xlTop Selection.VerticalAlignment = xlBottom Nikos Y. (nyannaco at in dot gr)
D Don Guillett Nov 10, 2003 #3 BTW, if you use Selection.HorizontalAlignment = xlCenterAcrossSelection instead of merging cells, if appropiate, you will be happier.
BTW, if you use Selection.HorizontalAlignment = xlCenterAcrossSelection instead of merging cells, if appropiate, you will be happier.
