Google is committed to advancing racial equity for Black communities. See how.

Compatible VBA APIs

The below VBA APIs have an equivalent API in Apps Script and can be successfully converted in most cases.

  • abs
  • application.activecell
  • application.activeprinter
  • application.activesheet
  • application.activeworkbook
  • application.alertbeforeoverwriting
  • application.application
  • application.asktoupdatelinks
  • application.autorecover
  • application.build
  • application.calculate
  • application.calculatefull
  • application.calculation
  • application.calculationstate
  • application.caption
  • application.celldraganddrop
  • application.centimeterstopoints
  • application.charts
  • application.columns
  • application.commandbars
  • application.copyobjectswithcells
  • application.cutcopymode
  • application.defaultfilepath
  • application.defaultsaveformat
  • application.defaultweboptions
  • application.displayalerts
  • application.displayclipboardwindow
  • application.displaycommentindicator
  • application.displayformulabar
  • application.displaynoteindicator
  • application.displayscrollbars
  • application.displaystatusbar
  • application.editdirectlyincell
  • application.enableanimations
  • application.enableautocomplete
  • application.enableevents
  • application.enablesound
  • application.getsaveasfilename
  • application.goto
  • application.help
  • application.hinstance
  • application.hlookup
  • application.hwnd
  • application.inchestopoints
  • application.interactive
  • application.intersect
  • application.iteration
  • application.left
  • application.mailsession
  • application.maxchange
  • application.maxiterations
  • application.moveafterreturn
  • application.moveafterreturndirection
  • application.name
  • application.names
  • application.networktemplatespath
  • application.operatingsystem
  • application.organizationname
  • application.path
  • application.pathseparator
  • application.printcommunication
  • application.quit
  • application.range
  • application.referencestyle
  • application.rollzoom
  • application.rows
  • application.screenupdating
  • application.selection
  • application.sheets
  • application.sheetsinnewworkbook
  • application.showstartupdialog
  • application.showtooltips
  • application.standardfont
  • application.standardfontsize
  • application.startuppath
  • application.statusbar
  • application.templatespath
  • application.thisworkbook
  • application.thousandsseparator
  • application.top
  • application.transitionmenukey
  • application.transitionmenukeyaction
  • application.transitionnavigkeys
  • application.union
  • application.usableheight
  • application.usablewidth
  • application.userlibrarypath
  • application.username
  • application.usesystemseparators
  • application.version
  • application.vlookup
  • application.volatile
  • application.wait
  • application.width
  • application.worksheetfunction
  • application.worksheets
  • areas.count
  • areas.item
  • asc
  • ascb
  • ascw
  • atn
  • autofilter.range
  • autofilter.showalldata
  • autofilter.sort
  • autorecover.enabled
  • autorecover.path
  • autorecover.time
  • border.color
  • border.colorindex
  • border.linestyle
  • border.themecolor
  • border.tintandshade
  • border.weight
  • borders.color
  • borders.colorindex
  • borders.item
  • borders.linestyle
  • borders.tintandshade
  • borders.value
  • borders.weight
  • cbool
  • ccur
  • cdate
  • cdbl
  • cdec
  • chart.application
  • chart.autoscaling
  • chart.chartarea
  • chart.charttitle
  • chart.charttype
  • chart.copy
  • chart.delete
  • chart.displayblanksas
  • chart.export
  • chart.hasdatatable
  • chart.haslegend
  • chart.haspivotfields
  • chart.hastitle
  • chart.index
  • chart.legend
  • chart.location
  • chart.move
  • chart.name
  • chart.parent
  • chart.paste
  • chart.perspective
  • chart.plotvisibleonly
  • chart.printout
  • chart.printpreview
  • chart.protectcontents
  • chart.rightangleaxes
  • chart.select
  • chart.seriescollection
  • chart.setsourcedata
  • chart.showallfieldbuttons
  • chart.tab
  • chart.visible
  • chartarea.autoscalefont
  • chartarea.height
  • chartarea.left
  • chartarea.shadow
  • chartarea.top
  • chartarea.width
  • chartfillformat.solid
  • chartobject.chart
  • chartobject.copy
  • chartobject.cut
  • chartobject.delete
  • chartobject.height
  • chartobject.left
  • chartobject.locked
  • chartobject.name
  • chartobject.parent
  • chartobject.placement
  • chartobject.top
  • chartobject.width
  • chartobjects.add
  • chartobjects.count
  • chartobjects.delete
  • chartobjects.item
  • chartsheet.activate
  • chartsheet.chartobjects
  • chartsheet.delete
  • chartsheet.move
  • chartsheet.name
  • chartsheet.select
  • chartsheet.visible
  • charttitle.autoscalefont
  • charttitle.caption
  • charttitle.text
  • choose
  • chr
  • chrw
  • cint
  • clng
  • clngptr
  • collection.add
  • collection.count
  • collection.item
  • collection.remove
  • commandbar.adaptivemenu
  • commandbar.height
  • commandbar.left
  • commandbar.top
  • commandbar.width
  • commandbarbutton.begingroup
  • commandbarbutton.builtin
  • commandbarbutton.builtinface
  • comment.delete
  • comment.parent
  • comment.visible
  • cos
  • createobject
  • cstr
  • customlayouts.paste
  • cverr
  • date
  • dateadd
  • datediff
  • datepart
  • dateserial
  • datevalue
  • day
  • debug.print
  • defaultweboptions.alwayssaveindefaultencoding
  • defaultweboptions.checkifofficeishtmleditor
  • defaultweboptions.loadpictures
  • defaultweboptions.savehiddendata
  • defaultweboptions.savenewwebpagesaswebarchives
  • defaultweboptions.updatelinksonsave
  • dictionary.add
  • dictionary.comparemode
  • dictionary.keys
  • documentproperty.linktocontent
  • documentproperty.name
  • documentproperty.type
  • documentproperty.value
  • environ
  • err.clear
  • err.description
  • err.number
  • err.raise
  • err.source
  • error
  • errorcheckingoptions.backgroundchecking
  • errorcheckingoptions.numberastext
  • exp
  • filelen
  • filter
  • fix
  • font.bold
  • font.color
  • font.colorindex
  • font.fontstyle
  • font.italic
  • font.name
  • font.outlinefont
  • font.shadow
  • font.size
  • font.strikethrough
  • font.subscript
  • font.superscript
  • font.themecolor
  • font.themefont
  • font.tintandshade
  • font.underline
  • format
  • formatconditions.add
  • formatconditions.item
  • formatdatetime
  • formatnumber
  • formatpercent
  • global.activecell
  • global.activesheet
  • global.activewindow
  • global.activeworkbook
  • global.application
  • global.calculate
  • global.cells
  • global.charts
  • global.columns
  • global.creator
  • global.err
  • global.intersect
  • global.load
  • global.names
  • global.parent
  • global.range
  • global.rows
  • global.selection
  • global.sheets
  • global.thisworkbook
  • global.union
  • global.unload
  • global.userforms
  • global.workbooks
  • global.worksheetfunction
  • global.worksheets
  • hex
  • hour
  • hyperlink.address
  • hyperlink.delete
  • hyperlink.follow
  • hyperlink.name
  • hyperlink.parent
  • hyperlink.range
  • hyperlink.screentip
  • hyperlink.subaddress
  • hyperlink.texttodisplay
  • hyperlinks.add
  • hyperlinks.count
  • hyperlinks.delete
  • iif
  • inputbox
  • instr
  • instrrev
  • int
  • interior.color
  • interior.colorindex
  • interior.pattern
  • interior.patterncolorindex
  • interior.patterntintandshade
  • interior.themecolor
  • interior.tintandshade
  • isarray
  • isdate
  • isempty
  • iserror
  • ismissing
  • isnull
  • isnumeric
  • isobject
  • join
  • lbound
  • lcase
  • left
  • legend.autoscalefont
  • legend.clear
  • legend.delete
  • legend.position
  • legend.shadow
  • len
  • lenb
  • log
  • ltrim
  • math.abs
  • math.round
  • mid
  • minute
  • month
  • monthname
  • msgbox
  • name.delete
  • name.name
  • name.refersto
  • name.referstorange
  • name.value
  • names.add
  • names.count
  • names.item
  • now
  • oct
  • oleobject.enabled
  • oleobject.visible
  • pagesetup.draft
  • pagesetup.printnotes
  • pictures.paste
  • pivotcache.createpivottable
  • pivotcaches.create
  • pivotfield.orientation
  • pivottable.adddatafield
  • pivottable.clearallfilters
  • pivottable.columngrand
  • pivottable.displayemptycolumn
  • pivottable.displayfieldcaptions
  • pivottable.enabledrilldown
  • pivottable.manualupdate
  • pivottable.parent
  • pivottable.pivotfields
  • pivottable.refreshtable
  • pivottable.rowgrand
  • pivottable.savedata
  • pivottable.showdrillindicators
  • pivottables.count
  • plotarea.name
  • pmt
  • qbcolor
  • querytable.backgroundquery
  • querytable.rownumbers
  • querytable.textfilepromptonrefresh
  • querytable.webdisableredirections
  • range.activate
  • range.addcomment
  • range.addindent
  • range.address
  • range.addresslocal
  • range.areas
  • range.autofill
  • range.autofilter
  • range.autofit
  • range.borderaround
  • range.borders
  • range.calculate
  • range.cells
  • range.characters
  • range.clear
  • range.clearcomments
  • range.clearcontents
  • range.clearformats
  • range.clearnotes
  • range.column
  • range.columndifferences
  • range.columns
  • range.columnwidth
  • range.comment
  • range.copy
  • range.count
  • range.countlarge
  • range.currentregion
  • range.cut
  • range.delete
  • range.dependents
  • range.end
  • range.entirecolumn
  • range.entirerow
  • range.exportasfixedformat
  • range.filldown
  • range.fillleft
  • range.fillright
  • range.fillup
  • range.find
  • range.findnext
  • range.font
  • range.formatconditions
  • range.formula
  • range.formular1c1
  • range.hasformula
  • range.height
  • range.horizontalalignment
  • range.hyperlinks
  • range.indentlevel
  • range.insert
  • range.interior
  • range.left
  • range.listnames
  • range.merge
  • range.mergearea
  • range.mergecells
  • range.name
  • range.next
  • range.numberformat
  • range.offset
  • range.orientation
  • range.parent
  • range.paste
  • range.pastespecial
  • range.pivottable
  • range.prefixcharacter
  • range.previous
  • range.printout
  • range.range
  • range.readingorder
  • range.removeduplicates
  • range.replace
  • range.resize
  • range.row
  • range.rowheight
  • range.rows
  • range.select
  • range.show
  • range.shrinktofit
  • range.sort
  • range.specialcells
  • range.style
  • range.text
  • range.texttocolumns
  • range.top
  • range.unmerge
  • range.usestandardheight
  • range.usestandardwidth
  • range.validation
  • range.value
  • range.verticalalignment
  • range.width
  • range.worksheet
  • range.wraptext
  • recentfiles.maximum
  • regexp.global
  • regexp.ignorecase
  • regexp.pattern
  • regexp.test
  • replace
  • rgb
  • right
  • rnd
  • round
  • rtrim
  • second
  • selection.paste
  • selection.pastespecial
  • series.markersize
  • series.markerstyle
  • series.shadow
  • series.trendlines
  • sgn
  • shape.placement
  • shaperange.visible
  • shapes.addpicture
  • shapes.paste
  • shapes.pastespecial
  • sheets.add
  • sheets.application
  • sheets.copy
  • sheets.count
  • sheets.delete
  • sheets.parent
  • sheets.printout
  • sheets.printpreview
  • sheets.select
  • sheets.visible
  • sin
  • slides.paste
  • sort.apply
  • sort.header
  • sort.matchcase
  • sort.orientation
  • sort.setrange
  • sort.sortfields
  • sort.sortmethod
  • sortfields.add
  • sortfields.clear
  • space
  • split
  • sqr
  • str
  • strcomp
  • strconv
  • string
  • strreverse
  • styles.count
  • tab.color
  • tab.colorindex
  • tab.themecolor
  • tan
  • textrange.paste
  • time
  • timer
  • timeserial
  • timevalue
  • trim
  • typename
  • ubound
  • ucase
  • userform.caption
  • val
  • validation.add
  • validation.delete
  • validation.ignoreblank
  • validation.incelldropdown
  • validation.inputmessage
  • validation.inputtitle
  • validation.showerror
  • validation.showinput
  • validation.type
  • vartype
  • weboptions.allowpng
  • weboptions.downloadcomponents
  • weboptions.relyoncss
  • weboptions.relyonvml
  • weboptions.uselongfilenames
  • weekday
  • weekdayname
  • window.activecell
  • window.activesheet
  • window.caption
  • window.close
  • window.displaygridlines
  • window.displayheadings
  • window.displayhorizontalscrollbar
  • window.displayoutline
  • window.displayverticalscrollbar
  • window.displayworkbooktabs
  • window.displayzeros
  • window.freezepanes
  • window.height
  • window.largescroll
  • window.left
  • window.rangeselection
  • window.scrollcolumn
  • window.scrollrow
  • window.scrollworkbooktabs
  • window.selectedsheets
  • window.selection
  • window.smallscroll
  • window.split
  • window.top
  • window.type
  • window.usableheight
  • window.usablewidth
  • window.view
  • window.visible
  • window.width
  • window.zoom
  • workbook.activate
  • workbook.activesheet
  • workbook.application
  • workbook.author
  • workbook.charts
  • workbook.close
  • workbook.colors
  • workbook.container
  • workbook.customdocumentproperties
  • workbook.enableautorecover
  • workbook.envelopevisible
  • workbook.exclusiveaccess
  • workbook.exportasfixedformat
  • workbook.fileformat
  • workbook.followhyperlink
  • workbook.fullname
  • workbook.fullnameurlencoded
  • workbook.hasroutingslip
  • workbook.multiuserediting
  • workbook.name
  • workbook.names
  • workbook.parent
  • workbook.password
  • workbook.path
  • workbook.pivotcaches
  • workbook.precisionasdisplayed
  • workbook.printout
  • workbook.printpreview
  • workbook.protect
  • workbook.protectwindows
  • workbook.readonly
  • workbook.readonlyrecommended
  • workbook.refreshall
  • workbook.resetcolors
  • workbook.save
  • workbook.saveas
  • workbook.savecopyas
  • workbook.saved
  • workbook.sendmail
  • workbook.sheets
  • workbook.unprotect
  • workbook.worksheets
  • workbooks.add
  • workbooks.count
  • workbooks.item
  • worksheet.activate
  • worksheet.application
  • worksheet.autofilter
  • worksheet.autofiltermode
  • worksheet.calculate
  • worksheet.cells
  • worksheet.chartobjects
  • worksheet.columns
  • worksheet.copy
  • worksheet.customproperties
  • worksheet.delete
  • worksheet.displayrighttoleft
  • worksheet.enableautofilter
  • worksheet.enableoutlining
  • worksheet.enableselection
  • worksheet.exportasfixedformat
  • worksheet.filtermode
  • worksheet.hyperlinks
  • worksheet.index
  • worksheet.move
  • worksheet.name
  • worksheet.names
  • worksheet.next
  • worksheet.parent
  • worksheet.paste
  • worksheet.pivottables
  • worksheet.previous
  • worksheet.printout
  • worksheet.printpreview
  • worksheet.protect
  • worksheet.protectcontents
  • worksheet.protectdrawingobjects
  • worksheet.protectionmode
  • worksheet.range
  • worksheet.rows
  • worksheet.select
  • worksheet.showalldata
  • worksheet.sort
  • worksheet.tab
  • worksheet.transitionexpeval
  • worksheet.type
  • worksheet.unprotect
  • worksheet.usedrange
  • worksheet.visible
  • worksheetfunction.acos
  • worksheetfunction.asin
  • worksheetfunction.average
  • worksheetfunction.averageif
  • worksheetfunction.binomdist
  • worksheetfunction.ceiling
  • worksheetfunction.chiinv
  • worksheetfunction.choose
  • worksheetfunction.clean
  • worksheetfunction.convert
  • worksheetfunction.correl
  • worksheetfunction.count
  • worksheetfunction.counta
  • worksheetfunction.countblank
  • worksheetfunction.countif
  • worksheetfunction.countifs
  • worksheetfunction.degrees
  • worksheetfunction.edate
  • worksheetfunction.even
  • worksheetfunction.find
  • worksheetfunction.floor
  • worksheetfunction.forecast
  • worksheetfunction.frequency
  • worksheetfunction.gammaln
  • worksheetfunction.gcd
  • worksheetfunction.hlookup
  • worksheetfunction.iferror
  • worksheetfunction.index
  • worksheetfunction.intercept
  • worksheetfunction.irr
  • worksheetfunction.iserr
  • worksheetfunction.iserror
  • worksheetfunction.isformula
  • worksheetfunction.islogical
  • worksheetfunction.isna
  • worksheetfunction.isnumber
  • worksheetfunction.istext
  • worksheetfunction.kurt
  • worksheetfunction.large
  • worksheetfunction.ln
  • worksheetfunction.log
  • worksheetfunction.lookup
  • worksheetfunction.match
  • worksheetfunction.max
  • worksheetfunction.median
  • worksheetfunction.min
  • worksheetfunction.mmult
  • worksheetfunction.mode
  • worksheetfunction.networkdays
  • worksheetfunction.normdist
  • worksheetfunction.norminv
  • worksheetfunction.normsdist
  • worksheetfunction.normsinv
  • worksheetfunction.npv
  • worksheetfunction.percentile
  • worksheetfunction.pi
  • worksheetfunction.poisson
  • worksheetfunction.power
  • worksheetfunction.product
  • worksheetfunction.proper
  • worksheetfunction.radians
  • worksheetfunction.randbetween
  • worksheetfunction.rank
  • worksheetfunction.replace
  • worksheetfunction.rept
  • worksheetfunction.roman
  • worksheetfunction.round
  • worksheetfunction.rounddown
  • worksheetfunction.roundup
  • worksheetfunction.rsq
  • worksheetfunction.search
  • worksheetfunction.skew
  • worksheetfunction.slope
  • worksheetfunction.small
  • worksheetfunction.stdev
  • worksheetfunction.substitute
  • worksheetfunction.subtotal
  • worksheetfunction.sum
  • worksheetfunction.sumif
  • worksheetfunction.sumifs
  • worksheetfunction.sumproduct
  • worksheetfunction.text
  • worksheetfunction.tinv
  • worksheetfunction.transpose
  • worksheetfunction.trim
  • worksheetfunction.vlookup
  • worksheetfunction.weekday
  • worksheetfunction.weeknum
  • worksheetfunction.workday
  • worksheets.add
  • worksheets.copy
  • worksheets.count
  • year