(Msg. 1) Posted: Fri Aug 08, 2008 1:29 pm
Post subject: find and replace all error message Archived from groups: microsoft>public>excel>crashesgpfs (more info?)
I am trying to create a macro that finds and replaces all cells with the text
"strongly disagree" with the number 1. When I click replace all, I get this
error message:
microsoft office 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 may be on a protected sheet. excel cannot
replace data on a protected worksheet.
I'm able to replace one cell at a time, but then I may miss some when I add
new data. If I can do replace all, I don't have to worry about missing any.
(Msg. 2) Posted: Sat Aug 09, 2008 3:45 pm
Post subject: RE: find and replace all error message [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
It would be helpful if you'd show your code.
--
HTH,
Barb Reinhardt
"Annemarie" wrote:
> I am trying to create a macro that finds and replaces all cells with the text
> "strongly disagree" with the number 1. When I click replace all, I get this
> error message:
>
> microsoft office 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 may be on a protected sheet. excel cannot
> replace data on a protected worksheet.
>
> I'm able to replace one cell at a time, but then I may miss some when I add
> new data. If I can do replace all, I don't have to worry about missing any.
>
> Any ideas?
(Msg. 3) Posted: Tue Aug 12, 2008 10:06 am
Post subject: RE: find and replace all error message [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
I didn't code anything, I only used the Record Macro option and it records
what I do.
"Barb Reinhardt" wrote:
> It would be helpful if you'd show your code.
> --
> HTH,
> Barb Reinhardt
>
>
>
> "Annemarie" wrote:
>
> > I am trying to create a macro that finds and replaces all cells with the text
> > "strongly disagree" with the number 1. When I click replace all, I get this
> > error message:
> >
> > microsoft office 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 may be on a protected sheet. excel cannot
> > replace data on a protected worksheet.
> >
> > I'm able to replace one cell at a time, but then I may miss some when I add
> > new data. If I can do replace all, I don't have to worry about missing any.
> >
> > Any ideas?
(Msg. 4) Posted: Tue Aug 12, 2008 1:27 pm
Post subject: RE: find and replace all error message [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Also, whether I'm running a macro or not, if i just do a regular find and
replace all, i get that error.
"Barb Reinhardt" wrote:
> It would be helpful if you'd show your code.
> --
> HTH,
> Barb Reinhardt
>
>
>
> "Annemarie" wrote:
>
> > I am trying to create a macro that finds and replaces all cells with the text
> > "strongly disagree" with the number 1. When I click replace all, I get this
> > error message:
> >
> > microsoft office 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 may be on a protected sheet. excel cannot
> > replace data on a protected worksheet.
> >
> > I'm able to replace one cell at a time, but then I may miss some when I add
> > new data. If I can do replace all, I don't have to worry about missing any.
> >
> > Any ideas?
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office