ExcelBanter - Selecting ranges with Cells()

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

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

- - Selecting ranges with Cells() (https://www.excelbanter.com/excel-programming/388499-re-selecting-ranges-cells.html)

Norman Jones

Selecting ranges with Cells()

Hi Robotman

Set Rng = Range("A1").Resize(1,5)

Alternatively:

Set Rng = Cells(1,1).Resize(1,5)

---
Regards,
Norman

All times are GMT +1. The time now is 05:20 PM.