VBA: Adjust Cells Displayed in Workbook Object

M

Minh

Hello!

Can someone please give me some VBA code that adjusts the viewable portion
of a worksheet object? For instance, if cells A1 to F5 are currently being
shown, how do I adjust the object to display A1 to G5? Thanks!

Minh
 
B

Brian Reilly, MVP

Minh,
If you use dynamically named ranges in Excel, then paste link the
current named range into PPT, when the named range changes size in
Excel, it will resize the object appropriately in PPT the next time
the link is updated.

There are many examples of dynamically sizing named ranges in Excel
with a google search.

Brian Reilly, MVP
 
Top