I am working on excel automation. How can I use the ctrl+d command for all the remaining cells in excel with write cell activity?
You need to use a for-each loop.
Or you need to read, manipulate in the datatable & then write back.
Thanks for your replay. do you have any other idea to use ctrl+d function?
you can use Write Cell "formula"
‘d’ for down and ‘u’ for up to simulate the hotkey. (You might be able to use Send Hotkey too.
I tried but it is not working, can you explain with screenshot?
Try this out.
This should fulfil your need.
ExcelWriteCell.zip (7.9 KB)
Any query let me know
Thanks, it’s working
Thanks a lot