View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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