ExcelBanter - Range("a21") .end(xlDown) or .end(xlUp) . offset(1,0) . value

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Range("a21") .end(xlDown) or .end(xlUp) . offset(1,0) . value (https://www.excelbanter.com/excel-programming/444058-re-range-a21-end-xldown-end-xlup-offset-1-0-value.html)

JDB[_2_]

Range("a21") .end(xlDown) or .end(xlUp) . offset(1,0) . value

Thanks for your comments.

JDB

All times are GMT +1. The time now is 08:31 PM.