View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
gti_jobert[_132_] gti_jobert[_132_] is offline
external usenet poster
 
Posts: 1
Default MSFlexGrid RemoveItem


Hi all,

I am populating an MSFlexGrid with rows of data manually on click of a
button....so it looks like the following:


Code:
--------------------

PD38 01822-00406 100394788 400 2 50 300 280 76000 600
11 50
PD38 01822-00406 100394791 50 11 20 30 280 4000 100
PD33 01810-10375 100394728 240 11 40 200 280 48000 300
PD33 01722-03509 100393890 210 1 20 160 260 29000 300
2 20
11 10
PD39 01821-00505 100398321 450 2 50 350 300 72000 500
11 50
PD07 01810-04998 100396409 450 11 80 370 240 72000 100
PD30 01722-03012 100390709 210 2 15 195 260 26000 200
PD30 01722-03010 100391991 240 2 10 210 260 32000 500
11 10
12 10

--------------------


As you can see from the above each *PD* can have a group of data. I
want to be able to click on .Col 0 in the MSFlexGrid and delete all
data that is grouped to the *PD* - I've been trying to use RemoveItem
(removes one line) but cant for the life of me think how to loop
through the data set and delete all data that belongs to a particular
*PD*.

Please help.....thanks all.


--
gti_jobert
------------------------------------------------------------------------
gti_jobert's Profile: http://www.excelforum.com/member.php...o&userid=30634
View this thread: http://www.excelforum.com/showthread...hreadid=553978