Depending on what your loop looks like...

Maybe you could do it like this instead of the loop:

Range("a1:A99").formula = "=Search("":"",Sheet2!A1,1)"


tam wrote:

Thanks, David. However, when I used this formula, I got "#NAME?". It looks
like the formula doesn't like the type of cell reference Cells(1,1). If I
changed cells(1,1) to A1, then everything worked fine. However, I have a
long list and I need to do a loop later on.
Regards,
Minh

"David Hepner" wrote:

Try this:

Range("A1").Formula = "=Search("":"",Sheet2!cells(1,1),1)"



"tam" wrote:

cells(1, 1).Formula = "=Search("":"",Sheet2!cells(1,1),1)"
What is wrong with this formula? How do I use this type of cell reference
in a formula?

--

Dave Peterson