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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA: Manipulate Workbook Object? 1
VBA for Dependents shortcut menu 0
Own Powerpoint shape like objects 0
Pasting a cell into bookmarked table from excel vba 1
Word VBA - Automatic change content of a cell in table using dropdown list 5
Word VBA - Delete text from bulleted paragraphs 1
At a loss for simple Visio VBA actions 1
lock cell 1

Top