View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ElectroAeroguy ElectroAeroguy is offline
external usenet poster
 
Posts: 3
Default how do I use a macro to center a shape in a cell in excel

Just that! I have a macro that copies various data to create a formatted
sheet, and I want a shape to be centered vertically and horizontally within
the cell after the cell is resized. Problem at present is that the shape
retains its alignment with the top border of the cell when the cell is
resized. I want to be able to center it.