Thread: Reference Cell Range Using Cell Value
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
  
Posts: 7,247
Default 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.



Reply With QuoteReply With Quote