Selecting several tables of varying size in non-contiguous range

[Kentetsu]

I have a sheet with 6 tables of varying size (length & width). The furthest Column used will be Column J.

So, I need to start at the bottom of Column A and go up to find the first populated cell, then extend that range to the top of the sheet and over to Column J.

I don't know why I'm having so much difficulty with this, as I've done it before and it was pretty simple from what I recall. But I've been wracking my brain on this all day and getting no traction at all.

If anyone can give me a hand with this, I would really appreciate it.

 

[Domenic]

You're very welcome!

 

[Peter_SSs]

Wow, a lot can happen when you go to bed for a few hours! Glad you boys got it sorted while I was in the land of nod.

 

[Kentetsu]

Well, being that you're on the other side of the world and all, you are forgiven. I really appreciate your time and help, and the opportunity to continue to learn from the masters.

 

[Domenic]

Wow, a lot can happen when you go to bed for a few hours!...