I want to code cell.find when the value will change?!?!?

[MrsTFB]

I'm using Excel97 and am trying to write a macro to find a value within a column based upon the text in another cell. Does this make sense? I've copied the value I want from original document into this spreadsheet. I want to do a search on a column to find the value in say Range("ar1&quot and add data to that particular row.

I've been successful in all of this except for coding the cell.find. It won't allow me to say Range("AR1&quot.text.

Any ideas?

Thanks in advance,

Bsimm

GO TITANS!

 

[dsi]

By the sounds of it, you may want to look into the VLOOKUP function.