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
|