ReplaceContent Method (Worksheet)

Searches into the content of the Worksheet and replaces all occurences of a specific value with a new value.

Syntax

Visual Basic
C#

'Declaration

 

Public Function ReplaceContent( _

   ByVal searchValue As Object, _

   ByVal newValue As Object _

) As Integer

'Usage

 

Dim instance As Worksheet

Dim searchValue As Object

Dim newValue As Object

Dim value As Integer

 

value = instance.ReplaceContent(searchValue, newValue)

public int ReplaceContent( 

   object searchValue,

   object newValue

)

Parameters

searchValue: The value that will be searched for.
newValue: The value that will replace all found instances of the searchValue.

Return Value

The total number of instances of the searchValue that were replaced within the content of the Worksheet.

Requirements

Target Platforms: Windows 11, Windows 10, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

Worksheet Class
Worksheet Members