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 loopCall 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 fileDeclare 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 messageExcel VBA loop through alphabet, Exponent, Extract year from date in Excel VbaFilter, 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 panesGet 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 dateHide columns; Hide rows; Hide sheet; Highlight a cell; HyperlinkIf Else; If statement; If Error; Include quotes in a string; Index; Index Match; Input; InsertJoin function; Jump; Jump to a lineKeep leading zerosLoad user form, Lock cells, Loop, Loop code; Loop through a column; Loop through a range; Loop through an array; Loop through rows; Loop through sheetsName 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 fileParse Json; Parse XML; Paste range; Paste special; Paste values; Pause; Press Enter key; Print; Print a variable; Print an arrayQuit Excel applicationReading 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 VBASave 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 stringText to columns; TEXTJOIN; Throw error; Transpose an array; Trim Excel; Trim string; Try-catch; Turn off screen updatingUnderline; 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 AscWWait Excel; Worksheet function; Wrap text; Write a text file; Write write to a cellXLOOKUPUnlock Excel's potential: Get your VBA macros eBook now!.