Hello forum. I have some VBA code in a PowerPoint (ppt is host) that makes a picture of an Excel Range (of cells) and inserts it into a ppt slide, it iterates 6 times for 6 different worksheets (currently) but the final version will operate on many dozens of worksheets. The code works but I have a problem. I have submitted the PowerPoint and the Excel workbooks (with junk data) to the forum so you can run the code yourself, and I have highlighted in the code where problem 1 exists. Here is a short description to get started.
In Excel I use the following syntax for range: Range(Cells(1,1),cells(5,5)).Select. This does not work in the context of the PowerPoint VBA and must resort to: Range(“A1:E5”).Select (as you will see in the code). I need to automate the row and column counters and the latter syntax is not very user friendly (at all) for that. Is there a way to switch back to the preferred syntax.
Incidentally, the title makes no sense, VBA is VBA, I am not sure how to word it, any suggestions?
Thanks for the help, this forum is great!.
Bookmarks