Error Adjusting Shape.Top Property when using VBA to copy from Excel to Powerpoint

[kelseygueldalewis]

I am working on a project that takes calendar information from excel, creates a powerpoint, and copies the data from excel into the powerpoint.

I am having trouble standardizing the Shape.Top position for a range that represents employee anniversary dates. In my code I say

Please Login or Register  to view this content.

I would like the range to be pasted 0.25" from the top of the slide, but when the powerpoint is created the areas land at varying horizontal positions from the top, and not at 0.25".

With other shapes it has worked fine, but this range the height changes depending on the number of employees that have anniversaries in that month, so I feel like it may have something to do with that? But I'm not sure how to fix it. Perhaps shape.top isn't the best method to use in the case?

Please Login or Register  to view this content.

I have included the spreadsheet with personal information removed for reference. The macro is called CreatePowerPoint.

[Andy Pope]

Try this revised code. Although you will need to correct the position of Anniversaries, as I assume you do not want it positioned over the calendar.

Please Login or Register  to view this content.

[kelseygueldalewis]

Thank you!
I'm not exactly sure why this worked, if it was adjusting the monthAnnEnd Variable, or the change in shape selection, but now all of the shape positioning is standardized