How to un-highlight pasted range? 1

[HughLerwill]

Dear All,

I'm manipulating some Excel Workbooks using VB6.

When pasting into a Sheet range the area pasted appears highlighted. It is possible to drop the highlight by doing something like;

Sheets(1).Cells(1,1).Select (or Activate)

but this will only work if the Sheet(instance of Excel) is visible. How can I get rid of the highlight on a Sheet which is not visible?

CutCopyMode is not doing it for me.

regards Hugh

 

[SkipVought]

Hugh,

Fully qualify the reference...

xlApp.Workbooks("WhichOne.xls").Worksheets("WhichSheet").Cells(1,1).Select

Skip,

_{[red]Be Advised![/red]
Alcohol and Calculus do not mix!
If you DRINK, don't DERIVE!}

 

[HughLerwill]

Skip,

Big thanks for that! How wierd?

regards Hugh,