Find and Replace

API	Description	Example
Range.Find	Function that finds specific data in the specified range and returns the corresponding range object	let range = instance.Application.ActiveSheet.Range("A1:B2"); let found = range.Find("Something");
Range.FindNext	Function that finds the next specific data in the specified range and returns the corresponding range object Note: Can be used after calling Range.Find function	let range = instance.Application.ActiveSheet.Range("A1:B2"); let found = range.Find("Something"); while (found != null) { found = range.FindNext(found); }
Range.FindPrevious	Function that finds the previous specific data in the specified range and returns the corresponding range object Note: Can be used after calling Range.Find function	let range = instance.Application.ActiveSheet.Range("A1:B2"); let found = range.Find("Something"); while (found != null) { found = range.FindPrevious(found); }
Range.Replace	Function that finds specific data in the specified range and replaces it with other data	let range = instance.Application.ActiveSheet.Range("A1:B2"); range.Replace({ What: "Something", Replacement: "Else" });