-1

I generated a graph using VBA and I have one specific bookmark in current word document. my challenge is to move the generated graph to the bookmark location. I searched a lot but in vain.

Can any body help me in getting VBA code for this. Thanks a lot for your time.

praveenstack
  • 9
  • 1

1 Answers1

0

Try playing with this to get the desired size/position

With ActiveSheet.ChartObjects("Chart 1")
     .Height = 325 ' set height
     .Width = 500 ' set width
     .Top = 100 ' Top position
     .Left = 200 ' Left position
End With

I would suggest, just guessing at the top and left position with trial and error to figure out the exact position you need it in.

Constuntine
  • 498
  • 2
  • 16
  • Thanks a lot for your response. I know how to generate a graph and I did that. my challenge is once I generate it, I need to move it to a place where there is a bookmark. – praveenstack Jul 14 '15 at 05:14
  • I updated my response. Check to see if you can make something like this work. – Constuntine Jul 14 '15 at 13:05