I also need this code to cycle through all cells down to row 300.

"Jeff Gross" wrote:

Sorry but I didn't make myself clear. I am copying from a different
worksheet into A2 if there is any data in B2.

Jeff.

"Patrick Molloy" wrote:

if Range("B2").Value <"" then Range("A2")=Range("B2").Value

"Jeff Gross" wrote in message
...
I need to copy text into a cell "A2" if there is any data in "B2". B2
contains a formula but will appear blank if its source has nothing.

Any ideas?

Jeff