I am trying to cut column D from a report and pasted it into column A
but I don't want to copy on top of colum A and loose it contents instead I want to shift column A to the right (to column B) and make room for column D
I think you may try to use InsertRange() method or InsertColumn method accordingly first with your desired ShiftType option before copying the actual range.
Aspose.Cells and VBA work on two different platforms, Aspose.Cells run on .NET framework and is actually build-up with a compiled language. The runtime engine of Aspose.Cells is .NET framework, while VBA is not a compiled language but a scripting language and its runtime environment is Ms-Office products.
So, it is highly unlikely that VBA code could be converted to Aspose.Cells code. But we will look into it further and see how such a thing could be achieved in future.