How to cancel a copy selection in Excel?

[Siv]

Hi,
Does anyone know how to cancel the selection of a block that has been copied
programmatically using C# and Excel Interop.

This is my current code:

rng=XLApp.get_Range("OrigRows",m); //selects the
row named OrigRows
XLApp.CutCopyMode = XlCutCopyMode.xlCopy;
rng.Select();
rng.Copy(m);
rng.Insert(XlInsertShiftDirection.xlShiftDown,m);

The above copies teh selected row in a sheet and then pastes it as a new
row.
Next I just want to cancel the selection, if I record the action of pressing
"Esc" in Excel it gives the code:

Application.CutCopyMode = False

When I try to do the same thing in C# I only get offered two options:

XlCutCopyMode.xlCopy
XlCutCopyMode.xlCut

How do I say:

XLApp.CutCopyMode=false;

As usual C# and VBA are highly incompatible (why???).

Siv

[chanmm]

rng is the Range object. You should be able to use the Range object in C#
as well.

chanmm
"Siv" <do****@removeme.sivill.comwrote in message
news:BC**********************************@microsof t.com...

Hi,
Does anyone know how to cancel the selection of a block that has been
copied programmatically using C# and Excel Interop.

This is my current code:

rng=XLApp.get_Range("OrigRows",m); //selects
the row named OrigRows
XLApp.CutCopyMode = XlCutCopyMode.xlCopy;
rng.Select();
rng.Copy(m);

rng.Insert(XlInsertShiftDirection.xlShiftDown,m);

The above copies teh selected row in a sheet and then pastes it as a new
row.
Next I just want to cancel the selection, if I record the action of
pressing "Esc" in Excel it gives the code:

Application.CutCopyMode = False

When I try to do the same thing in C# I only get offered two options:

XlCutCopyMode.xlCopy
XlCutCopyMode.xlCut

How do I say:

XLApp.CutCopyMode=false;

As usual C# and VBA are highly incompatible (why???).

Siv

[Siv]

I have looked at that and can't find anything that seems to cancel the
selection?
It's obviously obscure?

Cheers for responding.

Siv

"chanmm" <ch*****@hotmail.comwrote in message
news:%2***************@TK2MSFTNGP03.phx.gbl...

rng is the Range object. You should be able to use the Range object in C#
as well.

chanmm
"Siv" <do****@removeme.sivill.comwrote in message
news:BC**********************************@microsof t.com...

>Hi,
Does anyone know how to cancel the selection of a block that has been
copied programmatically using C# and Excel Interop.

This is my current code:

rng=XLApp.get_Range("OrigRows",m); //selects
the row named OrigRows
XLApp.CutCopyMode = XlCutCopyMode.xlCopy;
rng.Select();
rng.Copy(m);

rng.Insert(XlInsertShiftDirection.xlShiftDown,m );

The above copies teh selected row in a sheet and then pastes it as a new
row.
Next I just want to cancel the selection, if I record the action of
pressing "Esc" in Excel it gives the code:

Application.CutCopyMode = False

When I try to do the same thing in C# I only get offered two options:

XlCutCopyMode.xlCopy
XlCutCopyMode.xlCut

How do I say:

XLApp.CutCopyMode=false;

As usual C# and VBA are highly incompatible (why???).

Siv

[Mark Jerde]

Just a thought -- can you move the cursor?

-- Mark

Siv wrote:

I have looked at that and can't find anything that seems to cancel the
selection?
It's obviously obscure?

Cheers for responding.

Siv

"chanmm" <ch*****@hotmail.comwrote in message
news:%2***************@TK2MSFTNGP03.phx.gbl...

>rng is the Range object. You should be able to use the Range object
in C# as well.

chanmm
"Siv" <do****@removeme.sivill.comwrote in message
news:BC**********************************@microso ft.com...

>>Hi,
Does anyone know how to cancel the selection of a block that has
been copied programmatically using C# and Excel Interop.

This is my current code:

rng=XLApp.get_Range("OrigRows",m);
//selects the row named OrigRows
XLApp.CutCopyMode = XlCutCopyMode.xlCopy;
rng.Select();
rng.Copy(m);

rng.Insert(XlInsertShiftDirection.xlShiftDown,m) ;

The above copies teh selected row in a sheet and then pastes it as
a new row.
Next I just want to cancel the selection, if I record the action of
pressing "Esc" in Excel it gives the code:

Application.CutCopyMode = False

When I try to do the same thing in C# I only get offered two
options: XlCutCopyMode.xlCopy
XlCutCopyMode.xlCut

How do I say:

XLApp.CutCopyMode=false;

As usual C# and VBA are highly incompatible (why???).

Siv