View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
teepee[_3_] teepee[_3_] is offline
external usenet poster
 
Posts: 107
Default Indirect question

I want range ("CB4:CN289") to indirectly reference Range ("BL4:BX289")

As far as I can see I have to enter the indirect command into each cell
individually. Is there an obvious way of mass producing and doing it in one
go?

Many thanks