1) Select a single cell on the sheet. After the paste do a cells(1,1).select

2) ActiveWindow.Zoom = 80

Peter Richardson

"LetMeDoIt" wrote:

Greetings, my 2 issues seem a simple task but have not been able to
resolve either!

1- I have some VBA code that copies a range in a worksheet to another
workbook/worksheet. In the destination worksheet, once saved and
reopened retains the copy/paste highlight in the range copied. How do
I get rid of this?

2- I would like the zoom setting to be set to 80 when that new
workbook is opened. When that new worksheet is opened, it's set to
100%

I'm using the .PageSetup property which works well for printing only.

Any help is greatly appreciated.
regards, Letmedoit