Is there a list of VB addressable fields for Excel ?

[Fred]

See the subject really, i'm after a list of all VB addressable fields
for Excel/97 is such a thing exists.

Regards
Fred

 

[Bob Phillips]

or check the object browser

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Chip Pearson]

What is an "addressable field"?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Fred]

Apologies, I know what I mean, but expecting others to understand, I
suppose, is a little unreasonable.

I meant items such as :

ActiveSheet.PageSetup.PrintTitleRows
ActiveSheet.PageSetup.PrintTitleColumns
ActiveWindow.ScrollRow
ActiveSheet.Name
cell.Interior.ColorIndex
cell.Font.ColorIndex
cell.Interior.Pattern
cell.Interior.PatternColorIndex

Cheers
Fred

 

[Tom Ogilvy]

go to Chip Pearson's downloads page:

http://www.cpearson.com/excel/download.htm

and look for
TLIUtils
Provides VBA procedures for working with type libraries, via the TypeLib
Information object. Documentation of the available procedures is available
in the VBA code modules.