Is there a list of VB addressable fields for Excel ?
 

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

Regards
Fred

Is there a list of VB addressable fields for Excel ?
 

or check the object browser

--

HTH

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


"Dave Patrick" wrote in message
...
Do you mean constants? If so here's a start.

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

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

Is there a list of VB addressable fields for Excel ?
 

What is an "addressable field"?


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


"Fred" wrote in message
oups.com...
See the subject really, i'm after a list of all VB addressable
fields
for Excel/97 is such a thing exists.

Regards
Fred

Is there a list of VB addressable fields for Excel ?
 

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

Is there a list of VB addressable fields for Excel ?
 

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.

--
Regards,
Tom Ogilvy


"Fred" wrote in message
oups.com...
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