computer






 

Question by  spottedots (22)

How do you find and replace macro in excel?

I need to find and replace a macro in excel.

 
+6

Answer by  Helena (12)

In the menu bar select "Strument" - "Macro" (Alt+F8). Here you find the list of all the macro in your file. Here you can delete, modify, add all you want do. If your macro is in another file (alt+f8) and you select "Macro in" the file where is the macro.

 
+6

Answer by  NarenMukherjee (308)

Worksheets. Select What = InputBox("search word") repl = InputBox("replace word") Cells. Replace What:=What, Replacement:=repl, LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False End Sub

 
+5

Answer by  rajasingh (65)

Find macros by using Tools-> Macros->organise macros. The macros are displayed in the dialog box. If you find the name, you can replace the other macros with the same name

 
+5

Answer by  remisha (15)

If you want to use a macro that will automatically replace "1" to "ABC" then you can use the following code. Public Sub Priority() For Each cell In Selection cell.Value = Replace(cell.Value,"1","ABC") Next cell End Sub

 
+5

Answer by  jeyakumar (23)

Highlight the column that you need to edit.Go to Edit > Replace and enter an *text in the "Find what" box, leave the "Replace with" box blank. Click Replace All.

 
+4

Answer by  vijayparttimejob (2254)

in excel, it have find and replace option: Find option: 1. goto edit menu-> find. 2. Find dialogue box will appear. 3. Type your word to find->press find next option. Replace option: 1. Goto edit -> replace. 2. Type incorrect word in Find what text box and type replace word in replace with text box. 3. press replace button.

 
+3

Answer by  depika3 (156)

The excel document is spilit into more cells this cells are defined macros first delete current document and then enter the require text.

 
+3

Answer by  vicky (51)

Open excel. Then click on tools then scroll down to macro. Then go to macros. there you can find and replace macros. Shortcut key ALT F8.

 
You have 50 words left!