G
Guest
HI,
I WANT TO MERGE CELLS A2:A3 AND THEN ALIGN THR TEXT INSIDE VERTICALLY AND
HORIZONTALLY CENTERED.
Range("A2:A3").MergeCells = True
ActiveSheet.Cells(2, 1).HorizontalAlignment = xlCenter
ActiveSheet.Cells(2, 1).VerticalAlignment = xlVAlignCenter
THE CODE ABOVE DOES NOTHING.
CAN ANYBODY HELP ME?
THANKS
I WANT TO MERGE CELLS A2:A3 AND THEN ALIGN THR TEXT INSIDE VERTICALLY AND
HORIZONTALLY CENTERED.
Range("A2:A3").MergeCells = True
ActiveSheet.Cells(2, 1).HorizontalAlignment = xlCenter
ActiveSheet.Cells(2, 1).VerticalAlignment = xlVAlignCenter
THE CODE ABOVE DOES NOTHING.
CAN ANYBODY HELP ME?
THANKS