Excel copy from cell to cell

[Zheng1970]

Hello,

I am trying to use ActiveX to copy cell to cell with copy method of range. What should be data format of  destination?

Thanks!

[pitol · Accepted solution]

You cannot put a single cell there. It has to be a range. Create a range with the cell you want to have it copied to and it should work.

Destination	Optional	Specifies the new range to which the specified range will be copied. If this argument is omitted, Microsoft Excel copies the range to the Clipboard.

[aputman · Accepted solution]

Use the Worksheet->Range node for your destination.

[Zheng1970]

Thanks so much! It bothers me several days, I can have a nice sleep now.