Could you please check the attached small file on Sheet1, it contains just some cells in use, the others are blank.
Do you have idea maybe for a logic, which would check the whole sheet, and as result would identify the first and last cells of such "Blocks".
In the example I would mean on "Blocks" the
1) A1 first cell and last C10
2) E1 to H17
3) J1 to K6
As final target I would like to select the first block of data, around with ActiveSheet.Range(Cells(1,
1), Cells(10, 3)).Select, format and putting totals under of it, after going to the second etc. Just for this would need to know always, that actually which is the last cell of the block, because those can change. I did it manually in the file on Target sheet.