Hello,
I'm working on a franken-code from TheSpreadheetGuru's excellent multi-range to multi ppt slide guide at:
My issue is, I need to populate the MyRangeArray with data in a table (Sheet17, table name S"lidesA")
I've tried several variations of populating from a delimited string, creating a tempArray and basically every option listed in Dynamically Populating VBA Array Variables To Store Lists of Data — TheSpreadsheetGuru which all seem to run well to a print, but when I try to add them to my full code, give me an error 9 Subscript out of range.
My end goal:
This sheet (when all the bugs are worked out) will be sent to a non tech-savvy user who I do not want to have to instruct in messing with the code to change the arrays every month. I would like the MyRangeArray to auto-populate, either from a single cell with a delimited value, or from a table- whichever is easier.
The number of entries does not vary, but the ranges in the array change in depth.
Any guidance would be greatly appreciated!
I'm working on a franken-code from TheSpreadheetGuru's excellent multi-range to multi ppt slide guide at:
VBA Copy/Paste Multiple Excel Ranges To PowerPoint Slides
Learn how to automatically copy and paste multiple Excel ranges into individual PowerPoint slides with VBA macro coding.
www.thespreadsheetguru.com
My issue is, I need to populate the MyRangeArray with data in a table (Sheet17, table name S"lidesA")
VBA Code:
'List of Excel Ranges to Copy from
MyRangeArray = Array(Sheet23.Range("A5:B29"), Sheet23.Range("E5:F30"), Sheet23.Range("S5:T30"), Sheet23.Range("N5:O11"), Sheet23.Range("X5:Y11"), Sheet22.Range("A5:B27"), Sheet22.Range("E5:F26"), Sheet22.Range("I5:J27"), Sheet18.Range("A5:B32"), Sheet18.Range("E5:F25"), Sheet16.Range("A5:B23"))
I've tried several variations of populating from a delimited string, creating a tempArray and basically every option listed in Dynamically Populating VBA Array Variables To Store Lists of Data — TheSpreadsheetGuru which all seem to run well to a print, but when I try to add them to my full code, give me an error 9 Subscript out of range.
My end goal:
This sheet (when all the bugs are worked out) will be sent to a non tech-savvy user who I do not want to have to instruct in messing with the code to change the arrays every month. I would like the MyRangeArray to auto-populate, either from a single cell with a delimited value, or from a table- whichever is easier.
The number of entries does not vary, but the ranges in the array change in depth.
Any guidance would be greatly appreciated!