I don't have VB installed but If I want to give you a general clue for implementing an operation in
Interop
manner first start recording a macro in excel and then do your desired job and then stop recording.
Then go to view > macros and then edit the newly recorded macro. You should call the exact method and parameters as they are arranged in that macro.
For example for replacing we should add a reference to Microsoft.Interop.Excel and then have a code like this :
var oExel = new Excel.Application { DisplayAlerts = false };
oExel.Workbooks.Open(@"C:\abc.xlsx");
oExel.Application.Interactive = true;
oExel.Application.UserControl = true;
oExel.Visible = true;
oExel.Cells.Replace(What: "rain", Replacement: "snow", LookAt: XlLookAt.xlPart,
SearchOrder: XlSearchOrder.xlByRows
, MatchCase: false, SearchFormat: false, ReplaceFormat: false);
This code is in C# and It was converted from a macro which was recorded and they are almost exactly the same (replacement part I mean).
May be If you copy and paste that macro you do not need any change because you develop in VB language.
Hope It Helps