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:
Multiple ranges of cells BEFORE.JPG

My manager's goal is to have it arranged vertically, to look like this:
Multiple ranges of cells AFTER.JPG

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?