Require Foll. Syntax for Excel in VB6

[samyo]

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

[si_the_geek]

That's a lot of code (and explanations) you are asking for... the best thing to do for all except the last one is to create a Macro, then get the code from it (and if you dont understand parts of the code, select them and press F1).

To convert the Macro to VB6 code, see the Excel Tutorial link in my signature (post #11 I think). The tutorial also contains lots of other useful info for you, such as how to save (and open!) a file.