Would something like this work? Please post what code you have, it will
make it easier to see what you are trying to do.

for i = 1 to 100
if range("A" & i) = "apple"
'format text code
'copy to new location code
end if
next i

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!