View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sreedhar[_4_] sreedhar[_4_] is offline
external usenet poster
 
Posts: 1
Default RESIZE of matrix by MARCO


hi

MY problem is to resize the matrix after deletion for example

problem matrix:

1 0 1 0 1
0 0 1 0 1
1 0 0 1 0
0 1 0 0 1
1 0 0 1 0
...............
...............

for example after deleting rows 2 and 4 like this

1 0 1 0 1

1 0 0 1 0

1 0 0 1 0
................
................

we have to resize the matrix by bring 3 row into 2 and if 4 exist i
should be in 3 else if 5 row exist it should bring to 3 row likewis
end of the page.

1 0 1 0 1
1 0 0 1 0
1 0 0 1 0

so can any one plz help me regarding this as soon as possible

thanks
sre

--
sreedha
-----------------------------------------------------------------------
sreedhar's Profile: http://www.excelforum.com/member.php...fo&userid=2758
View this thread: http://www.excelforum.com/showthread.php?threadid=47324