Help: Find a row and then delete it

[kotzo]

Hi,

Im using

For counter=1 To 100
c=activesheet.cells.find(a).offset(0,3).value

d=c/10 [I] This is an example of the computations[/I]


' ********** DELETE THE ROW ***************

Next counter

in order to find 3 different rows that contain the a value
and then to use the 3rd cell on the right.

(100 are the nr. of all the rows I have)

After, that i need to delete these 3 rows but one after the other (offcourse)


Is it possible

a) to propose a better method
b) to show me how can I find the coordinates of the3 rows I found ?

Thanks

Kotzo

 

[kotzo]

Hi again,

based on the last post, it would be also a help
if you could tell me, if it is possible to
find the coordinates of the row that I found with the


c=activesheet.cells.find(a).offset(0,3).value

code

In other words:

If found the value c.
But where is it ?



Regards,

Kotzo

 

[kotzo]

Hi,

Is it possbile to give an answer ?

Thanks