11-07-2019 07:21 AM
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!
Solved! Go to Solution.
11-07-2019 08:52 AM
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.
11-07-2019 09:10 AM
Use the Worksheet->Range node for your destination.
11-07-2019 09:38 AM
Thanks so much! It bothers me several days, I can have a nice sleep now.