Excel Method List (VBA)

Excel Function                      
Excel Function  (VBA)           
Excel Object Property (VBA)
Excel Event (VBA)                  

This page lists all Excel Method for VBA that have been explained in this website.

You may also want to read:

Differences among Function, Sub, Method, Property

 

Chart Method

Method Description
ExportAsFixedFormat Export Chart to PDF

 

Range Method

Method Description
Copy Copy and then paste a Range
ExportAsFixedFormat Export Range to PDF
PasteSpecial Use Paste Special options to paste a range

 

Workbook Method

Method Description

ExportAsFixedFormat

Export Workbook to PDF
FollowHyperlink Open hyperlink in web browser
LinkInfo Return the link status of workbook
LinkSources Return array of workbook names of external data
Protect
RefreshAll Refresh all external data and Pivot Tables
Save
Unprotect
UpdateLink Refresh external data

 

Workbooks Method

Method Description
Add Create a new workbook
FollowHyperlink Open hyperlink in web browser
Open Open a closed workbook from another workbook

 

Worksheet Method

Method Description
Unprotect Unprotect protected worksheet
Protect Prevent users from editing worksheet
Select Select a single or multiple worksheet

 

Worksheets Method

Method Description
Add Create a new worksheet
Copy Copy worksheet
AutoFilterMode Check if AutoFilter is active in worksheet
ExportAsFixedFormat Export Worksheet to PDF
FilterMode Check if data is hidden
Paste Paste clipboard contents
ShowAllData Unhide hidden data

 

Worksheets Object Method

Method Description
AutoFilter.Sort.Apply Apply sorting to AutoFilter
AutoFilter.Sort.SortFields.Add Add AutoFilter sorting criteria
AutoFilter.Sort.SortFields.Clear Clear AutoFilter sorting
Range.Intersect Find the common Range of two or more Range
Range.Sort Sort a Range
Range.Union Combine two or more Range and set as a new Range
PivotTable.RefreshTable Refreshes the PivotTable report from the source data
PivotTable.PivotCache().Refresh()   Updates the cache of the PivotTable object

 

Application Method

Method Description
Inputbox Prompt a box for user input
OnKey Assign hotkey to Macro (Sub Procedure)
OnTime Schedule event at specific time or after specific time
Volatile Force to recalculate user defined Functions

 

Dictionary Method

Method Description
Add Add Item to Dictionary
Count Count number of Item in Dictionary
Exists Check if Item already exists in Dictionary
Items Return all Items in Dictionary
Keys Return all Keys in Dictionary
Remove Remove an Item in Dictionary
RemoveAll Remove all Item in Dictionary

 

FileSystemObject Method

Method Description
CopyFile Copy a file to another location
CopyFolder Copy a folder to another location
CreateFolder Create a folder in a location
DeleteFile Delete a file in a location
DeleteFolder Delete a folder in a location
FileExists Check if a file exists in a location
FolderExists Check if a folder exists in a location
GetFile Return file Object
GetFileName Return the name of file
GetFolder Return folder Object
GetParentFolderName Return the name of the parent folder of the last component in a specified path
GetSpecialFolder Return the special folder object specified
MoveFile Move a file to another location
MoveFolder Move a folder to another location