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
[table width=”750″ colwidth=”150|600″ ]
Method, Description
ExportAsFixedFormat, Export Chart to PDF
[/table]
Range Method
[table width=”750″ colwidth=”150|600″ ]
Method, Description
Copy, Copy and then paste a Range
ExportAsFixedFormat, Export Range to PDF
PasteSpecial, Use Paste Special options to paste a range
[/table]
Workbook Method
[table width=”750″ colwidth=”150|600″ ]
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
[/table]
Workbooks Method
[table width=”750″ colwidth=”150|600″ ]
Method, Description
Add,Create a new workbook
FollowHyperlink, Open hyperlink in web browser
Open, Open a closed workbook from another workbook
[/table]
Worksheet Method
[table width=”750″ colwidth=”150|600″ ]
Method, Description
Unprotect, Unprotect protected worksheet
Protect, Prevent users from editing worksheet
Select, Select a single or multiple worksheet
[/table]
Worksheets Method
[table width=”750″ colwidth=”150|600″ ]
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
[/table]
Worksheets Object Method
[table width=”750″ colwidth=”150|600″ ]
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
[/table]
Application Method
[table width=”750″ colwidth=”150|600″ ]
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
[/table]
Dictionary Method
[table width=”750″ colwidth=”150|600″ ]
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
[/table]
FileSystemObject Method
[table width=”750″ colwidth=”150|600″ ]
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
[/table]