2 Attachment(s)
VBA to dynamically select EACH block/range of cells on a worksheet, then copy/paste?
I'm working with data that comes from Business Objects. I cannot control the output format. Currently, the data is exported as several charts (that come through as picture objects) and several (sorta)tables. The chart picture objects are (mostly) all next to each other, horizontally across the sheet. The (sorta)tables are all in the row(s) beneath the chart picture objects. It looks like this:
Attachment 24122
My manager's goal is to have it arranged vertically, to look like this:
Attachment 24123
She wants each (sorta)table copied/pasted as a picture object. So, in English, the steps go like this:
- Evaluate the current cell
- If it is not blank, select the entire range of contiguous cells, copy it, paste it as a picture
- Go to the next non-blank cell that's NOT a part of the current range, select that new range, copy, paste
- Repeat until all (sorta)tables are pasted as pictures
- Go to the next sheet, continue evaluating
I can say it in English just fine....translating that to VBA is another matter entirely. I've tried working with CurrentRegion, end(xltoright), named ranges, etc. I have reached various levels of success, but am still falling short. Any suggestions?