I want following syntax for using in Excel thru vb6

formulas
1. How to get ="D5*E5" 1. for full 1 column or a range
2. Upto Particular rows
or 3. Pasting the formulas in each row

1A Syntax for copying a formula


2. Syntax for Cell Formating
with Number Decimal Places
with Alignment Text ; degrees
with border
with Pattern
with Wraptext
with Merge Cells

3. Syntax for Vlookup

4. Syntax for Inserting Row and Column

5. Syntax for Inserting Row and Column

6. Syntax for Data Sort

7. Syntax for Freezing Panes

8. Syntax for Saving a file or worksheet



Regards

Samyo