VBA Code For Excel
Finding the Last Populated Cell, Row, or Column in a Worksheet
Sub Last_Real_Populated_Cell()Move to a Cell in Excel
ActiveCell.SpecialCells(xlLastCell).Select
LastR = ActiveCell.Row
LastC = ActiveCell.Column
Cells(theRow, theCol).SelectUsing a Spreadsheet for Flash Cards
This VBA Excel macro code shows how you can use a speadsheet instead of flash cards.
VBA Excel Importing a Text File
Code to import a comma separated text file into Excel.
VBA Excel Range Usage
In VBA Excel Range can be used in three basic ways. The first way is to directly refer to the Range. For example...
Excel VBA Get Column LetterYou can, with Excel VBA get column letter or letters in two basic ways. The first would be...
Deleting a Column in Excel VBASub Delete_Column_Excel_VBA()Excel Worksheets Add Method
Columns("F:F").Select
Selection.Delete Shift:=xlToLeft
End Sub
Your options with the Excel Worksheets VBA add method are all Optional and they are...
Export the VBA in Excel, Word, etc.
You can export the VBA in Excel, Word, etc. by adding a reference to the "Microsoft Visual Basic for Applications Extensibility 5.3" and using the following code...
Excel VBA Progress Bar
To create an Excel VBA progressbar...
Importing Tab Delimited Data into Excel
The file imported is a text file. You can import other types of files such as .xml and .csv, and also database tables and queries from Access projects, Access database files, ODBC, other Excel files, and others...
Excel VBA tutorial
Welcome to our Excel VBA tutorial start page...
VBA Sleep Excel
VBA Sleep Excel is accomplished by using the Sleep API call...
Excel VBA Forms
You can create Excel VBA forms (Excel VBA userforms) in the VBA editor which you display while the workbook is open...
.
Go from VBA Code For Excel to VBA Code Samples
