SReplacment = InputBox("With what", csTITLE) SWhat = InputBox("Replace what", csTITLE) The following macro provides an example.ĭim sWhat As String, sReplacment As StringĬonst csTITLE As String = "Find and Replace" It is a rather trivial task to access what is stored in the various parts of the header and footer, check them for what you want to find, and then replace it with some new text. The only way to handle the finding and replacing of information in a header or footer is to use a macro. One place that Find and Replace won't work, however, is with information stored in headers or footers for your worksheets. One of the very useful tools provided in Excel is Find and Replace, which allows you to locate and change information stored in cells.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |