Thread: Dynamic range generator
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jarek Kujawa[_2_] Jarek Kujawa[_2_] is offline
external usenet poster
  
Posts: 896
Default Dynamic range generator
=D21*32&"&&-"&D21*32+31

presuming RTDMA is in D21

you might also give D21 a name of "RTDMA"

and then use the formula:

=RTDMA*32&"&&-"&RTDMA*32+31

HIH
Reply With QuoteReply With Quote