Thread: MERGE CELLS
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ermeko ermeko is offline
external usenet poster
 
Posts: 28
Default MERGE CELLS

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