## Compatible VBA APIs The following 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` ## Related articles - [Macro Converter Google Workspace add-on overview](https://developers.google.com/apps-script/guides/macro-converter/overview) - [Determine if VBA macros are compatible](https://developers.google.com/apps-script/guides/macro-converter/compatibility-report) - [Convert VBA macros to Apps Script](https://developers.google.com/apps-script/guides/macro-converter/convert-files) - [Fix errors in your converted code](https://developers.google.com/apps-script/guides/macro-converter/fix-conversion-errors) - [Address common issues](https://developers.google.com/apps-script/guides/macro-converter/address-conversion-issues) - [Watch Macro Converter tutorials](https://developers.google.com/apps-script/guides/macro-converter/tutorials)