I have been trying to do a find and replace on selected cells only, but it seems to replace in the entire sheet, although not consistently. Can't quite seem to nail down when it does the whole sheet and when it just does the selected cells. Any suggestions on ensuring that replace only takes place on selected cells?
Thanks
David
Hi David
Would you like to upload a small, sample workbook of what are you trying to do??
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Hello,
How is your range selected?
By highlighting the cells
Hmmm....never thought of that.Originally Posted by Davidns
Are the highlight cells Noncontiguous?
Note: I guess that doesn't matter, I just tried to replicate the problem and can't.
Although it has happened to me on occasion.
Last edited by davesexcel; 03-20-2012 at 05:02 AM.
..That's why i asked for a sample workbook!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks