ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Error Message When Using Replace (https://www.excelbanter.com/excel-programming/355308-error-message-when-using-replace.html)

Susan

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


All times are GMT +1. The time now is 09:32 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com