Un Selecting Range of Cells

[Rocky0201]

Hi...

I have a routine that copy's a row of cells (Column A through Column L, Row x) and then paste special format on the next row.

This all works great.

After I finish the routine (x number of for loops) I am finished with the macro. The problem is that the last row that I selected to copy remains selected i.e., traveling dashes.

Is there an un select that I can use on the range of cells that I last copied?

Thanks.

 

[Rick Rothstein]

You can remove the "travelling dashes" with this command...

Application.CutCopyMode = False

As for eliminating the selection itself (assuming you selected the cells beforehand, which is not necessary to do), you can simply select any single cell. So, you could do this...

Range("A1").Select

or, if you just wanted to select the first cell in the current selection, you could do this...

Selection(1).Select

 

[Rocky0201]

Thanks Rick...

I used: Application.CutCopyMode = False and it worked great!!