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.
Similar threads
- Question
