This Excel VBA tutorial explains how to copy Range and paste data using VBA
Excel VBA Copy Range Method
Range.Copy Method is a very convenient Method to copy and paste Range to destination in one line of code. All the formatting will be copied and pasted.
You can copy a Range, a column, a row.
Syntax
Range.Copy(Destination)
Destination is optional. If not specified, Excel copies the Range to the Clipboard.
In some cases, we may just want to copy to Clipboard and then use Paste/PasteSp...
Read More
Unit 6 – Excel VBA Methods
Excel export Excel to PDF with VBA
This Excel tutorial explains how to export Excel to PDF with and without VBA, how to export all worksheets to one PDF, and export all worksheets to separate PDF.
You may also want to read:
Select multiple worksheets using Excel VBA
How to Convert Excel to PDF (non VBA)
Excel export Excel to PDF (non-VBA)
In Excel, you can easily export Excel to PDF by navigating to File > Save As, in the Save As Type, you can save a file as different file types. Below is the available types in E...
Read More
Excel VBA Inputbox and Application.Inputbox
This Excel tutorial explains difference between VBA Inputbox and Application.Inputbox and how to use them.
You may also want to read:
Excel VBA Msgbox and handling of return value
Excel VBA use Inputbox to select options
Excel VBA Inputbox and Application.Inputbox
Inputbox is a pop up dialog box that displays a message and provides a text box for users to input free text. It is very similar to Msgbox except that Msgbox does not have a text box for user input.
There are two kinds of Inputbox...
Read More
Access Excel FSO File Methods
This Access / Excel tutorial explains how to use FSO File related Methods including FileExists, DeleteFile, MoveFile, CopyFile
You may also want to read:
Loop workbooks in folders and subfolders
Access Excel FSO Folder Methods
FSO File Methods
FileSystemObject (FSO) provides an API to access the Windows filesystem such as accessing Drive, TextStram, Folder, File. In this tutorial, I will only explain the use of some important File related Methods. For details, please read the MSDN lib...
Read More
Access Excel FSO Folder Methods
This Access / Excel tutorial explains how to use FSO Folder related Methods including FolderExists, CreateFolder, DeleteFolder, MoveFolder, CopyFolder
You may also want to read:
Loop workbooks in folders and subfolders
FSO File Methods
FSO Folder Methods
FileSystemObject (FSO) provides an API to access the Windows filesystem such as accessing Drive, TextStram, Folder, File. In this tutorial, I will only explain the use of some important Folder related Methods. For details, please read...
Read More
Excel VBA Application Volatile Method to force recalculate
This Excel tutorial explains the use of Application Volatile Method to recalculate custom Function (User Defined Function).
You may also want to read:
Excel Workbook Calculation Automatic and Manual
Excel VBA Application Volatile Method
In Excel VBA, you can create your own Functions, we call it User Defined Function (UDF), usually I simply call it custom Function. Function is a Procedure that can take argument and return a value.
There are two kinds of custom Functions.
The first ...
Read More
Excel Range Sort Method to sort data
This Excel tutorial explains how to sort Excel data using Excel VBA Sort Method, and how to sort dynamic Range.
You may also want to read:
Sort data using custom Function by Bubble Sort
Sort data using custom Function by assigning number to Text
Sort data using Table AutoFilter
Sort data using Worksheet AutoFilter
Excel Range Sort Method to sort data
There are mainly three kinds of sorting in Excel.
1 - Table AutoFilter sorting, using List Object to access AutoFilter.
2 - ...
Read More
Excel VBA Workbook LinkSources Method to find external links
This Excel tutorial explains how to use Workbook LinksSources Method in Excel VBA to find all external links.
You may also want to read:
How to refresh all external data of closed workbook
Excel find all external links and broken links in workbook
Excel VBA Workbook LinkSources Method
LinkSources can be used to return an array of names of linked documents, editions, DDE or OLE servers.
Assume that you have two formula that link to another workbook, for example
='C:\Users\WYMAN\Des...
Read More
Access Excel Scripting Dictionary store unique array item
This Access Excel tutorial explains how to use Scripting.Dictionary in VBA to store unique array item.
You may also want to read:
Access Excel VBA Array
Remove duplicates in text using Dictionary
Excel VBA filter value then copy data to new worksheet
Access Excel VBA Scripting.Dictionary to store unique array item
An associative array, map, symbol table, or dictionary is an abstract data type composed of a collection of (key, value) pairs, such that each possible key appears just once ...
Read More
Excel VBA Application.OnTime Method to schedule event with timer
This tutorial explains how to use Excel Application.OnTime Method to trigger / schedule event at specified time.
You may also want to read:
Auto Open Excel with Windows Task Scheduler
Excel automatically refresh pivot table
Excel VBA Application.OnTime Method to trigger event at specified time
You can do the followings with Excel VBA Application.OnTime Method
- schedule a procedure to be run at a specified time in the future
- schedule a procedure to be run after a specific amou...
Read More