Insert multiple cells with the option shift cells down
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
03-01-18 09:43 AM
I want to Insert multiple cells with the option shift cells down
For example, there is data in the excel, the cursor is currently at A422, if I want to Insert 25 cells, and move the data in A423 down, what parameter should I use to "Insert" cells and shift the existing cells down also without using "insert" action 25 times
Insert adds cells and shifts then "up" or "Left" each of them have a different code -4161 for Left and -4121 for Up. similarly if there is a code for shifting the cells down while inserting then that would be of great use.
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
03-01-18 06:05 PM
The MS Excel VBO Blue Prism provices is comprehensive but it is impossible to provice actions that will fullfill every use case that users will ever have - that is why this guide: https://portal.blueprism.com/system/files/2017-11/Excel%20Automation%20… includes a section called ""Extending the MS Excel VBO with new functionality"".
If there is functionality you need that is currently missing, there is nothing stopping you from adding it yourself!
