Quantitative Analysis
Parallel Processing
Numerical Analysis
C++ Multithreading
Python for Excel
Python Utilities
Services
Author

I. Motivation and design (PFE).
II. Installation of the Python for Excel.
III. Tutorial introduction into the Python for Excel.
IV. PFE Programmer's reference.
1. Direct access to Excel API.
A. Application object (PFE).
B. Workbooks object (PFE).
C. Workbook object (PFE).
D. Worksheets object (PFE).
E. Worksheet object (PFE).
a. Activate method (vba.Worksheet).
b. Calculate method (vba.Worksheet).
c. Cells property (vba.Worksheet).
d. Columns property (vba.Worksheet).
e. CopyAfter method (vba.Worksheet).
f. CopyBefore (vba.Worksheet).
g. Delete method (vba.Worksheet).
h. Dispatch property (vba.Worksheet).
i. Hyperlinks property (vba.Worksheet).
j. Index method (vba.Worksheet).
k. MoveAfter method (vba.Worksheet).
l. MoveBefore method (vba.Worksheet).
m. Name property (vba.Worksheet).
n. Names property (vba.Worksheet).
o. Parent property (vba.Worksheet).
p. Range method (vba.Worksheet).
q. Rows property (vba.Worksheet).
r. Visible property (vba.Worksheet).
F. Range object (PFE).
G. Borders object (PFE).
H. Border object (PFE).
I. Interior object (PFE).
J. Names object (PFE).
K. Name object (PFE).
L. Font object (PFE).
2. Lower level access to Excel API.
3. Event trapping (PFE).
4. Configuration files (PFE).
Index. Contents.

MoveBefore method (vba.Worksheet).


he MoveBefore method moves the represented worksheet before the worksheet given by its only argument.

Check that you are not moving before itself or into the same position. Such call not only would throw exception but also would destabilize the application.


Figure


Figure


Figure





Index. Contents.


















Copyright 2007