I have a code which adds a new chart in ppt. Then opens up the chartdata workbook and pastes in the data from an excel file. However, the source data range does not expands according to the data pasted. Can this be done dynamically using Excel VBA? I tired resizing the Table but the vba is not able to identify if is a table or not.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Excel Facts
Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
Similar threads
- Question
- Replies
- 1
- Views
- 665
- Replies
- 2
- Views
- 246
- Question
- Replies
- 4
- Views
- 86
