Powershell and Excel Merging Cells

How do I merge cells in Column A,B and C in excel?

Like this:


$ws1.Cells.Item($row,1) = "Note: Users listed are either in the BuiltIn\Administrators group or are in a group that is in the BuiltIn\Administrators group."

 $MergeCells = $ws1.Range("A${Row}:C$row")
 $MergeCells.Select()
 $MergeCells.MergeCells = $true

Advertisements