ajjava
Board Regular
- Joined
- Dec 11, 2018
- Messages
- 57
- Office Version
- 365
- Platform
- Windows
I have a worksheet that contains several ranges of contiguous, non-blank cells (they look like tables but are not technically defined as such).
I need some code that will select the range of contiguous cells, copy it, then paste as a picture.
Then it needs to proceed to the next range contiguous cells, copy, paste as a picture, etc. etc.
This data is getting into Excel via an export from Business Objects.
The number of table-like structures can vary from sheet to sheet, and there are multiple sheets. I'd want the code to loop through all table-like structures and through all sheets.
Can anybody suggest the correct code? From the research I've done, I'm thinking of employing the SpecialCells method...am I barking up the right tree?
[/URL]https://i.imgur.com/jK8sFaL.jpg[/img][/IMG]
I need some code that will select the range of contiguous cells, copy it, then paste as a picture.
Then it needs to proceed to the next range contiguous cells, copy, paste as a picture, etc. etc.
This data is getting into Excel via an export from Business Objects.
The number of table-like structures can vary from sheet to sheet, and there are multiple sheets. I'd want the code to loop through all table-like structures and through all sheets.
Can anybody suggest the correct code? From the research I've done, I'm thinking of employing the SpecialCells method...am I barking up the right tree?
![jK8sFaL.jpg](/board/proxy.php?image=http%3A%2F%2F%5BURL%3D%22https%3A%2F%2Fimgur.com%2FjK8sFaL%22%5D%5BIMG%5Dhttp%3A%2F%2Fi.imgur.com%2FjK8sFaL.jpg&hash=2a8d5cfaa58b73f8bcb8a628c192db0b)
Last edited: