Folks,

rng.PasteSpecial(Excel.XlPasteType.xlPasteValues,
Excel.XlPasteSpecialOperation.xlPasteSpecialOperat ionNone,
Type.Missing, Type.Missing);

Does not seem to work. Nor does.

rng.PasteSpecial(Excel.XlPasteType.xlPasteValues,
Excel.XlPasteSpecialOperation.xlPasteSpecialOperat ionNone,
false, false);

I'm having trouble finding the right parameter for the third one, object
SkipBlanks and object Transpose.

Clues?


--
Bob Sullentrup

rng.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _
True, Transpose:=True

This may help.

Good Luck.


Folks,

rng.PasteSpecial(Excel.XlPasteType.xlPasteValues,
Excel.XlPasteSpecialOperation.xlPasteSpecialOperat ionNone,
Type.Missing, Type.Missing);

Does not seem to work. Nor does.

rng.PasteSpecial(Excel.XlPasteType.xlPasteValues,
Excel.XlPasteSpecialOperation.xlPasteSpecialOperat ionNone,
false, false);

I'm having trouble finding the right parameter for the third one
object
SkipBlanks and object Transpose.

Clues

--
goobe
-----------------------------------------------------------------------
goober's Profile: http://www.excelforum.com/member.php...fo&userid=1983
View this thread: http://www.excelforum.com/showthread.php?threadid=48201

Goober,

Thanks for the response.

Do you happen to know what the Visual Studio Tools For Office (VSTO) version
of that VBA snippet might be?

thanks.

--
Bob Sullentrup


"Bob Sullentrup" wrote:

Folks,

rng.PasteSpecial(Excel.XlPasteType.xlPasteValues,
Excel.XlPasteSpecialOperation.xlPasteSpecialOperat ionNone,
Type.Missing, Type.Missing);

Does not seem to work. Nor does.

rng.PasteSpecial(Excel.XlPasteType.xlPasteValues,
Excel.XlPasteSpecialOperation.xlPasteSpecialOperat ionNone,
false, false);

I'm having trouble finding the right parameter for the third one, object
SkipBlanks and object Transpose.

Clues?


--
Bob Sullentrup