.match error in two dimensions

[TildesleyH]

Hi Excel Forum,

I am trying to find the address of the smallest value within a two-dimensional range.

This code is working fine when the range is in one dimension but returns the error "unable to get the match property of the worksheetfunction class" when the range is in two dimensions. I have pasted a section below which returns this error:

Please Login or Register  to view this content.

The range in worksheet3 contains the following:

blank	0.002796
blank	0.003196
blank	0.003596

Is anyone able to help me get this working?

[TildesleyH]

Thank you everyone but I have found a solution! Posting for the next poor fellow

Please Login or Register  to view this content.

[johnnyL]

Since post #2 does not match up to the code in post #1,

For clarification, I am supplying possible resolution for code posted in post #1.

Please Login or Register  to view this content.