Help to find a value in an array

[vazqueza]

Hi:

I'm trying to write a macro to find a value in a column and get some data from it's row. The value can be repeated several times. I wrote the following macro, but it's working only to find the first value. After that I'm getting this error:

Run-time error '1004':
Method 'Range' of object '_Global' failed

Really I don't know what is going on. I'll appreciate any help.

Thanks

Armando

Please Login or Register  to view this content.

[StevenM]

You gave the error number, but you didn't specify the line where the error occurred.

Instead of:

Please Login or Register  to view this content.

Perhaps something like:

Please Login or Register  to view this content.

The find method returns the Cell/Range of the first cell in a given Range that satisfies a criterion.

Then you need to find out if this Range is not nothing, although it has to be written:

Please Login or Register  to view this content.

[vazqueza]

Thanks StevenM, it works similar to the original code. When I find the first value I need to set a new range in order to find the second one, for that reason I'm using Cell1 and Cell 2 as a range. When the range is set form the first row number found untill the last row in the range, I'm getting the same error.