cancel
Showing results for 
Search instead for 
Did you mean: 

Insert multiple cells with the option shift cells down

RekhaMurari
Level 2
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

Denis__Dennehy
Level 15
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!