View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] Bunter_22@hotmail.com is offline
external usenet poster
 
Posts: 37
Default for each cell in range....direction problem

Hi Sunil,

In V1 you have B3:C11 then later B12:C20 then later B21:C29 why can't
that be written as B3:C29 similarly you have this with all of them? You
could then combine V1 and V2 and your entire range would be made of 2/3
of what you currently have as V1.

Have I misinterpreted what you were asking for?

James