Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Moving columns in Excel programmatically
Message
 
 
To
13/04/2011 13:49:08
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 8
OS:
Windows XP
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01507161
Message ID:
01507164
Views:
48
>How may I move a column in Excel programmatically? Code in macro doesn't work properly in VFP.
>
>Columns("BC:BC").Select
>Selection.Cut
>Range("C1").Select
>Selection.Insert Shift:=xlToRight
>
>"Insert Shift" nor "xlToRight" are not recognized by VFP.

Check Re: How to insert a Column in Excel worksheet ? Thread #1450904 Message #1450929

and also Re: How to move the range down in excel ? Thread #1365010 Message #1365011
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform