I would like an array that takes this table (i will call it TableA):
<tbody>
GrandTotal
Total1
Total2
(empty cell)
Total3
Total1
Apples
Beatles
Cats
Total2
Bananas
Stones
Who
Total3
Cherries
</tbody>
<tbody>
</tbody>
(would ideally like a msgbox to ask the sheetname and...