How to set the fomula in a cell ? - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

How to set the fomula in a cell ?

Message

De

27/10/2010 22:57:12

Yim Ming Sun Derek
Spacious Design Consultant
Hong Kong, Hong Kong

À

Tous

Information générale

Forum:

Visual FoxPro

Catégorie:

Codage, syntaxe et commandes

Titre:

How to set the fomula in a cell ?

Versions des environnements

Visual FoxPro:

VFP 9 SP2

OS:

Windows XP SP2

Network:

Windows 2003 Server

Database:

Visual FoxPro

Application:

Desktop

Divers

Thread ID:

01487323

Message ID:

01487323

Vues:

97

Hi,

I want to set a SUM fomula to a cell, but the cell is "?NAME#'

lnLastRow = oExcel.activesheet.UsedRange.Rows.Count
oExcel.activesheet.Cells(lnLastRow+1,1).Formula = '=SUM(cells(1,1):cells(lnLastRow,1))

Please advise.

Derek Yim

Click here to load this message in the networking platform