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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s