Select a Range with Excel VBA
This course will show you how to use Range, Cells, Offset, Resize and Union to select a range in Excel VBA. Take this free course now!
Writing VBA statements
A statement in VBA is a complete instruction. It can contain keywords, operators, variables, constants, and expressions. Each statement belongs to one […]
Excel Macro: Highlight the Active Row and Column
The VBA code examples show ways to highlight the active cell or the rows and columns that contain the active cell. Get the VBA code now!
Range.Column property Range.CurrentRegion property Range.Select method Range.EntireColumn property Range.EntireRow property IsEmpty function Worksheet.SelectionChange event Worksheet.BeforeDoubleClick event Application.ScreenUpdating property Interior.ColorIndex property Range.Interior property Range.Address property On Error statement
Excel Macro: Zoom In and Out in Worksheet on Double-Click
Sometimes, if you want to zoom in and out in a worksheet, you need to have a finger on CTRL and the […]
Excel Macro: Create a Table of Contents of Sheets
This Excel macro not only creates a table of contents at the beginning of the workbook, but it also adds hyperlinks. Get this VBA code now!
Excel Macro: Protect or Unprotect All Worksheets At Once
Is there any way to have a Macro protect or unprotect multiple worksheets at once in Excel quickly and easily? This Macro do this! Get it now!
Excel Macro: Create a New Workbook for Each Sheet
Sometimes you may need to create a new workbook for each sheet, it seems very boring to do it manually, this macro can help you. Get it now!
Excel Macro: Group Worksheets by Color
If you assign colors to your Worksheet tabs, you may want to sort or group Worksheets based on their tab colors, this macro can help you.
Excel Macro: Sort Worksheets by Name
If you want to sort multiple worksheets by name, it seems very boring to do it manually. In this situations, you can use this simple macro.
Go To Special with VBA
You can use Excel VBA to quickly find and select all cells that contain a specific type of data, just like using the Go To Specials command.
Formatting Cells Number with VBA
You can learn: formatting cells number with VBA code examples, Excel built-in number formats, custom number formats.
Formatting Cells Alignment with VBA
You can learn: Formatting Cells Alignment with VBA, include Text Alignment, Text Control, Right-to-left and Orientation. Take this course now!
Range.IndentLevel property Range.AddIndent property Range.Orientation property XlOrientation enumeration Range.ReadingOrder property XlReadingOrder enumeration Range.MergeCells property Range.ShrinkToFit property Range.WrapText property Range.VerticalAlignment property XlHAlign enumeration Range.HorizontalAlignment property