Forums
|
Blogs
|
Contact Us
|
Zoho Home
VBA Object Explorer
The following Microsoft
®
Excel Classes and VBA Modules are supported in Zoho Sheet.
Excel Classes
VBA Modules
<Globals>
Application
Areas
Axis
AxisTitle
Border
Borders
Chart
ChartObject
ChartObjects
ChartTitle
Comment
Comments
Conversion
DateTime
Financial
Font
Hyperlink
Hyperlinks
Information
Interaction
Interior
Math
Name
Names
Range
RoutingSlip
Sheets
Strings
Window
Windows
Workbook
Worksheet
WorksheetFunction
Worksheets
Spreadsheet Objects
»
Application
:
Properties:
ActiveCell
ActiveChart
ActiveSheet
ActiveWindow
ActiveWorkbook
Application
Cells
Charts
Columns
DisplayAlerts
EnableEvents
Names
Parent
Range
Rows
ScreenUpdating
Selection
Sheets
ThisWorkbook
Windows
Workbooks
WorksheetFunction
Worksheets
Methods:
Calculate
CalculateFull
CentimetersToPoints
InchesToPoints
Intersect
Union
Properties:
Application
Item
Parent
Methods:
No methods for this class
Properties:
Application
AxiisTitle
HasTitle
Parent
Methods:
No methods for this class
Properties:
Application
Caption
Parent
Text
Methods:
Delete
Properties:
Application
Color
LineStyle
Parent
Weight
Methods:
No methods for this class
Properties:
Application
Color
Item
LineStyle
Parent
Value
Weight
Methods:
No methods for this class
Properties:
Application
ChartTitle
ChartType
HasLegend
HasTitle
Parent
Methods:
ApplyDataLabels
Axes
Delete
Refresh
SetSourceData
Properties:
Application
Chart
Height
Left
Name
Parent
Top
Width
Methods:
Delete
Dupliacate
Properties:
Application
Height
Left
Parent
Top
Width
Methods:
Add
Delete
Dupliacate
Item
Properties:
Application
Caption
Parent
Text
Methods:
Delete
Properties:
Application
Parent
Methods:
Delete
Next
Previous
Text
Properties:
Application
Parent
Methods:
Item
Properties:
Application
Bold
Color
ColorIndex
FontStyle
Italic
Name
Parent
Size
Strikethrough
Underline
Methods:
No methods for this class
Properties:
Address
Application
Name
Parent
Range
TextToDisplay
Methods:
Delete
Properties:
Application
Parent
Methods:
Add
Delete
Properties:
Application
Parent
Color
ColorIndex
Methods:
No methods for this class
Properties:
Application
Name
Parent
RefersTo
RefersToR1C1
RefersToRange
Methods:
Delete
Properties:
Application
Parent
Methods:
Add
Item
Properties:
Address
Application
Areas
Borders
Cells
Column
Columns
Comment
ColumnWidth
CurrentRegion
Dependents
DirectDependents
DirectPrecedents
End
EntireColumn
EntireRow
Font
Formula
FormulaR1C1
HasFormula
HorizontalAlignment
Hyperlinks
Interior
Item
MergeCells
MergeArea
Name
NumberFormat
Offset
Parent
Precedents
Range
Resize
Row
Rows
RowHeight
Text
Value
Value2
VerticalAlignment
WorkSheet
WrapText
Methods:
Activate
AddComment
AutoFill
AutoFit
BorderAround
Calculate
Clear
ClearComments
ClearContents
ClearFormats
ClearNotes
Copy
Cut
DataSeries
Delete
FillDown
FillLeft
FillRight
FillUp
GoalSeek
Insert
Merge
Select
UnMerge
Sort
SpecialCells
Properties:
Application
Delivery
Message
Parent
Recipients
Status
Subject
Methods:
Reset
Properties:
Application
Parent
Methods:
Add
Properties:
ActiveCell
ActiveChart
ActiveSheet
Application
Caption
Parent
RangeSelection
Selection
Methods:
No methods for this class
Properties:
Application
Parent
Methods:
No methods for this class
Properties:
ActiveChart
ActiveSheet
Application
Charts
HasRoutingSlip
Name
Names
Parent
Routed
RoutigSlip
Sheets
Windows
Worksheets
Methods:
Route
Save
SaveAs
SaveCopyAs
SendMail
Properties:
Application
Parent
Methods:
Add
Properties:
Application
Parent
Methods:
Acos
Acosh
And
Asc
Asin
Asinh
Atan2
Atanh
Average
Bin2DEc
Bin2Hex
Bin2Oct
Ceiling
Choose
Clean
Combin
Convert
Count
CountA
CountBlank
CountIf
Days360
Dec2Bin
Dec2Hex
Dec2Oct
Degrees
Dollar
Even
EDate
EoMonth
Fact
Find
FindB
Fixed
Floor
Gcd
Hex2Dec
Hex2Oct
Hex2Bin
HLookup
Index
IsEven
IsErr
IsError
IsLogical
IsNA
IsNonText
IsNumber
IsOdd
IsText
Large
Lcm
Ln
Log
Log10
Lookup
Match
Max
Min
MRound
MultiNomial
NetworkDays
Oct2Hex
Oct2Bin
Oct2Hex
Odd
Or
Pi
Power
Product
Proper
Quotient
Radians
RandBetween
Replace
ReplaceB
Rept
Roman
Round
RoundDown
RoundUp
Search
SearchB
SeriesSum
Small
StDev
StDevp
Substitute
SubTotal
Sum
SumIf
SumSq
Tanh
Text
Trim
Var
VarP
VLookup
WeekDay
WeekNum
WorkDay
YearFrac
Properties:
Application
Parent
Methods:
Add
FillAcrossSheets
Properties:
Application
Cells
Columns
Comments
Hyperlinks
Index
Name
Names
Parent
Range
Rows
UsedRange
Methods:
Activate
Calculate
ChartObjects
Copy
Delete
Move
Select
Paste
All properties and methods under VBA modules are globals (i.e., they can be used directly without prefixing the respective module name).
Following properties and methods are globals that can be used directly without prefixing its object name.
Properties:
ActiveCell
ActiveChart
ActiveSheet
ActiveWindow
ActiveWorkbook
Application
Cells
Charts
Columns
Names
Parent
Range
Rows
Selection
Sheets
ThisWorkbook
Windows
Workbooks
WorksheetFunction
Worksheets
Methods:
Calculate
Intersect
Union
Properties:
Date
Date$
Now
Time
Time$
Methods:
DateAdd
DateDiff
DatePart
DateSerial
DateValue
Day
Hour
Minute
Month
Second
TimeSerial
TimeValue
Timer
Weekday
Year
Properties:
No properties for this module
Methods:
FV
IPmt
NPV
NPer
PPmt
PV
Pmt
Rate
SLN
SYD
Properties:
No properties for this module
Methods:
IsArray
IsDate
IsEmpty
IsNumeric
IsObject
QBColor
RGB
TypeName
VarType
Properties:
No properties for this module
Methods:
Choose
IIf
Partition
Switch
MsgBox
Properties:
No properties for this module
Methods:
Abs
Atn
Cos
Exp
Log
Rnd
Round
Sgn
Sin
Sqr
Tan
Properties:
No properties for this module
Methods:
Asc
AscB
Ascw
Chr
Chr$
ChrB
ChrB$
ChrW
ChrW$
Filter
Format
Format$
FormatCurrency
FormatDateTime
FormatPercent
FormatNumber
InStr
InStrB
InStrRev
Join
LCase
LCase$
LTrim
LTrim$
Left
Left$
LeftB
LeftB$
Len
LenB
Mid
Mid$
MidB
MidB$
MonthName
RTrim
RTrim$
Replace
Right
Right$
RightB
RightB$
Space
Space$
Split
StrComp
StrConv
StrReverse
String
String$
Trim
Trim$
UCase
UCase$
WeekdayName
Properties:
No properties for this module
Methods:
CBool
CByte
CCur
CDate
CDbl
CDec
CInt
CLng
CSng
CStr
CVDate
CVar
Fix