I believe you want to find the current region of A1 and surrounding cells – not necessarily all cells on the sheet.
If so – simply use…
Range(“A1”).CurrentRegion
I believe you want to find the current region of A1 and surrounding cells – not necessarily all cells on the sheet.
If so – simply use…
Range(“A1”).CurrentRegion