Thread: How can I use a cell value to reference a row?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Excelchallenged Excelchallenged is offline
external usenet poster
  
Posts: 4
Default How can I use a cell value to reference a row?
a5 is an integer variable from 15 to 925 in increments of 1. When a5 is 20
cell a10 (or any cell I chose) should read the contents of j20. When a5 is
825 cell a10 should read the contents of j825. The integer value in a5
defines the row of column j returned in cell a10.
Reply With QuoteReply With Quote