MS Excel VBO Insert option

[waziaks]

Hi,

I was trying to use "Insert" inside the MS excel vbo for learning purpose, but I am unable to find how to use "Shift (Left or Up)" option. Refer the attached screen shot.

Please provide your inputs

Thanks
waziak

 

[waziaks]

Hey champs please reply

 

[gil.silva]

Hello waziaks,

The Insert action works together with other actions: Select and Copy.
Basically it will Insert your data from the clipboard (CTRL + C), after the current selected cell in the Excel.
The shift will determine if you want to insert in the vertical (DOWN) or horizontal (RIGHT)
You can read more about the Insert method here: https://docs.microsoft.com/en-us/office/vba/api/excel.range.insert

 

[waziaks]

Thanks I'll give it a try

 

[stefahp]

i need help with add column in the firts column, how can add this?