please help in grouping rows of excel throgh vb6.0 code

[zaza]

You could sort:

Range("A1:D200").sort("A:A")

which will change the rows around, or to only display certain types at any one time just set a filter (select the first column, then Tools, Autofilter).

zaza