I am using the following code to edit data cell by cell:

r.Columns(i).Replace What:="", Replacement:=vbLf

I get a Microsoft error "Microsoft Excel cannot find any
data to replace. Check if your search formatting and
criteria are defined correctly. If you are sure that
matching data exists in this workbook, it my be on a
protected sheet. Excel cannot replace data on a protected
worksheet."

I have run this application on Excel 2000/97 with no
problems. I have not seen this problem until Excel 2002.

HOWEVER: THE DATA IS EDITED, regardless of the error
messagebox saying that it will not edit the data. How do
I manage the protection of this worksheet with VB in order
to prevent getting the excel message?

Archived from group: microsoft>public>vb>ole