View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Susan Susan is offline
external usenet poster
 
Posts: 271
Default Error Message When Using Replace

I have renamed Sheet 1 in my workbook and am trying to replace the text,
using the "Replace" function under the Edit menu, in my VB Code file that
refers to Sheet 1 with the new name I have given the sheet. When I type the
new name in "Replace With," I get an error that says that the "Search Text
Cannot be Found." Can someone please tell me what I am doing wrong?

Susan Spencer