VBA to dynamically select the next range of used cells?

[ajjava]

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]

 

[ajjava]

Oh, my bad. I was in the process of testing the excellent solutions I've received. I will remember this rule in the future.

 

[ajjava]

igold
I really appreciate your efforts with this. I'm still getting weird results and can't pinpoint why. But no further efforts are necessary here, as I think I may have a solution that accomplishes my goal. Thank you again

 

[igold]

That's great, I am glad you got what you needed. Thanks for the feedback.