VBA - trying to find cell in range

[cmefly]

Hi,

I'm trying to find a cell in range("A1:I50") and trying to report back the column numbers

is this possible.....??

thanks,

marc

 

[jmthompson]

What is you criteria for finding the cell?

 

[cmefly]

sheet 1 contains the range

sheet 2, cell A1 contains the text that i'm looking for - i'm looking for the entire cell...

does this help?

 

[jmthompson]

Is it possible that there would be more than one match?

Where do you want the column number published?

 

[cmefly]

no, not more than one match.

just assign it to a variable...

 

[cmefly]

can someone please take a stab at this...? much appreciated.

 

[cmefly]

Please help if you can.....