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.
Cookie Notice
To provide you with the best experience, we use cookies for personalization, analytics, and ads. By using our site, you agree to our cookie policy.
Enables storage, such as cookies, related to analytics.
Sets consent for sending user data to Google for online advertising purposes.
Sets consent for personalized advertising.
Cookie Notice
To provide you with the best experience, we use cookies for personalization, analytics, and ads. By using our site, you agree to our cookie policy.
More info
Enables storage, such as cookies, related to analytics.
Enables storage, such as cookies, related to advertising.
Sets consent for sending user data to Google for online advertising purposes.
Sets consent for personalized advertising.
Cookie Notice
To provide you with the best experience, we use cookies for personalization, analytics, and ads. By using our site, you agree to our cookie policy.
More info
Enables storage, such as cookies, related to analytics.
Enables storage, such as cookies, related to advertising.
Sets consent for sending user data to Google for online advertising purposes.