TTom
Well-known Member
- Joined
- Jan 19, 2005
- Messages
- 518
I know how to set a range A1 to last cell data row & column if there are no blank cells, but how do I find the last
cell range (row, column) if there are blank cells, rows, and/or columns, before the lowest, right most cell with data?
Only works until hits a blank cell in column A or blank cell in row 1?
<code>
Set rng1 = Range(Cells(1, 1), Cells(Range("A65000").End(xlUp).Row, Range("IV1").End(xlToLeft).Column))
</code>
cell range (row, column) if there are blank cells, rows, and/or columns, before the lowest, right most cell with data?
Only works until hits a blank cell in column A or blank cell in row 1?
<code>
Set rng1 = Range(Cells(1, 1), Cells(Range("A65000").End(xlUp).Row, Range("IV1").End(xlToLeft).Column))
</code>