ExcelBanter - Reference Cell Range Using Cell Value

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

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

- - Reference Cell Range Using Cell Value (https://www.excelbanter.com/excel-programming/327012-reference-cell-range-using-cell-value.html)

Jeff M[_5_]

Reference Cell Range Using Cell Value

How can I select a cell range referencing the value in a
cell?

i.e. Range("A3:A" & "(=VALUE(R3)").Select

The value in Cell R3 represent the number of records.

Chip Pearson

Reference Cell Range Using Cell Value

Try

Range("A3:A" & Range("R3").Value).Select

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Jeff M" wrote in message
...
How can I select a cell range referencing the value in a
cell?

i.e. Range("A3:A" & "(=VALUE(R3)").Select

The value in Cell R3 represent the number of records.

Jeff M[_5_]

Reference Cell Range Using Cell Value

Thank you!!!

-----Original Message-----
Try

Range("A3:A" & Range("R3").Value).Select

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Jeff M" wrote in
message
...
How can I select a cell range referencing the value in a
cell?

i.e. Range("A3:A" & "(=VALUE(R3)").Select

The value in Cell R3 represent the number of records.

.

All times are GMT +1. The time now is 06:56 AM.