by Klemens Nguyen (Author)
In this book you can find:
- over 202 ready to use macros,
- VBA listings,
- no theory - only practical examples,
- most frequently searched macro topics on Google.
Are you looking for macro? Check table of contents:
Block comment; Bold text in Excel; Bold text in Word; Break code; Break for loop; Break line; Break line in MsgBox; Break out of loop; Break while loop
Call a function; Call a sub; Check if a sheet exists; Close a workbook; Close a workbook; Comment multiple lines; Concatenate; Convert column number to letter; Convert number stored as text to number; Convert number to letter; Convert string to number; Convert string to text; Convert string yyyymmdd to date, Convert xls to xlsx; Copy and paste; Create a JSON file; Create xml file
Declare a variable, Declare array; Delete a file; Delete a row; Delete a sheet; Delete columns; Deselect in Excel; Deselect in Word; Dim; Dim array; Dim range; Dim text; Dim variable; Dim worksheet; Display a message
Excel VBA loop through alphabet, Exponent, Extract year from date in Excel Vba
Filter, Filter a column; Filter a table; Find Excel; Find and replace; Find date; Find duplicates; Find error; Find error code; Find function; Find last column; Find last row; Find string; For loop; Format date; Format text; Freeze panes
Get cell value; Get current time; Get current year; Get date; Get file name; Get last row; Get length of array; Get month; Get month and year from date; Get remainder; Get sheet name; Get substring; Get the value of a cell; Get time; Get today's date; Get username; Get value from key in dictionary VBA 124; Get workbook name; Get year; Get yesterday date
Hide columns; Hide rows; Hide sheet; Highlight a cell; Hyperlink
If Else; If statement; If Error; Include quotes in a string; Index; Index Match; Input; Insert
Join function; Jump; Jump to a line
Keep leading zeros
Load user form, Lock cells, Loop, Loop code; Loop through a column; Loop through a range; Loop through an array; Loop through rows; Loop through sheets
Name a chart; Name a column; Name a file; Name a new workbook; Name a range; Name a shape; Name a sheet; Name a workbook; Name active workbook; Number value excel VBA;
Offset a range; Offset active cell; Open a csv file; Open a folder; Open a new workbook; Open a text file in Excel; Open a user form; Open a Word document; Open a workbook; Open Excel; Open hyperlink; Open xlsx file
Parse Json; Parse XML; Paste range; Paste special; Paste values; Pause; Press Enter key; Print; Print a variable; Print an array
Quit Excel application
Reading data from a cell; Read text file; Read XML file in excel VBA; Redim an array; Refresh all queries Excel; Refresh Pivot Table; Refresh power query; Refresh query table; Remove double quotes from string; Remove duplicates; Remove filter; Rename a file; Rename a sheet; Return a value from a function; Round up; Run a query in Access VBA; Run JavaScript; Run SQL query; Run update query in Access VBA
Save as; Save file; Save workbook; Save XLSM file; Save XLSM file as XLSX; Save XLSX file; Select a cell; Select a sheet; Sendkeys VBA; Set a cell value; Set a range; Set row height in Excel VBA; Sgn; Split a string
Text to columns; TEXTJOIN; Throw error; Transpose an array; Trim Excel; Trim string; Try-catch; Turn off screen updating
Underline; Unfilter; Unhide sheet; Unmerge cells; Unprotect Excel sheet; Unselect; Use between; Use Dim, Use Dim function; Use e; Use Excel function; Use find; Use immediate window; Use Json converter; Use MsgBox Yes No; Use Or; Use VLOOKUP; Use XLDOWN;
VBA operator; VBA AscW
Wait Excel; Worksheet function; Wrap text; Write a text file; Write write to a cell
XLOOKUPUnlock Excel's potential: Get your VBA macros eBook now!
Number of Pages: 322
Dimensions: 0.67 x 9 x 6 IN
Publication Date: March 18, 2024
