Unselect Range to top left cell

[pkew22]

I have a macro where I select a range of cells and concatenate the selected cells. (I am copying and pasting from Word and the lines are not appearing on the same cell).

Once this macro runs it concatenates correctly but there are several rows that are selected.

I only want to wrap text on the first cell (top left cell).

How do I unselect all cells except the top cell?

I am using Excel 2007.

I have this this line:
selection.wraptext = true

I want to apply this to only the first cell in the selection.

Thank you.

[TMS]

Maybe:

Please Login or Register  to view this content.

Regards, TMS

[Norie]

You could use this.

Please Login or Register  to view this content.

PS You probably don't need to select anything to do what you want

[TMS]

Thanks for the rep.