How to access all cells with formula in a Worksheet

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

How to access all cells with formula in a Worksheet

Message

From

08/10/2006 01:20:26

08/10/2006 00:21:11

General information

Forum:

Visual FoxPro

Category:

COM/DCOM and OLE Automation

Title:

Environment versions

Visual FoxPro:

VFP 9 SP1

OS:

Windows XP SP2

Network:

Windows 2000 Server

Database:

Visual FoxPro

Miscellaneous

Thread ID:

01160368

Message ID:

01160373

Views:

Alternatively, rewritting Sergey's codes with FOR EACH syntex,

FOR each ocell in oSheet.UsedRange.cells
    IF ocell.HasFormula
	* There's a formula in the current cell
	...
    ENDIF
ENDFOR

HTH

Steven