Sign-In
Cart
How to do this in VBA? 202 ready-made macros: Streamline your tasks with proven expert solutions
Paperback
Series: VBA & Macros, Book 18
Please select the version of book you would like to purchase.
ISBN13: 9798320142555
Publisher: Independently Published
Published: Mar 18 2024
Pages: 322
Weight: 0.95
Height: 0.67 Width: 6.00 Depth: 9.00
Language: English
Publisher: Independently Published
Published: Mar 18 2024
Pages: 322
Weight: 0.95
Height: 0.67 Width: 6.00 Depth: 9.00
Language: English
In this book you can find:
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
- over 202 ready to use macros,
- VBA listings,
- no theory - only practical examples,
- most frequently searched macro topics on Google.
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
XLOOKUP
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
XLOOKUP
Unlock Excel's potential: Get your VBA macros eBook now!
Also from
Nguyen, Klemens
AI-Powered Excel: Automate Reports, Workflows & Business Tasks with Office Scripts and Power Automate
Nguyen, Klemens
Paperback
$17.99
Excel VBA for Absolute Beginners: Master Macros & Automation in Just 7 Days!
Nguyen, Klemens
Paperback
$10.13
VBA for Word 365 for practitioners.: Detailed instructions how to step-by-step customize examples.
Nguyen, Klemens
Paperback
$8.39
Grounding, Shielding & EMC for Builders: Quiet Circuits: Practical Grounding, Shielding & EMC for Projects
Nguyen, Klemens
Paperback
$20.39
Excel 365 formulas unleashed: The ultimate guide to mastering the top 88 power formulas for ultimate productivity
Nguyen, Klemens
Paperback
$8.39
Introduction to the Arduino Nano: Overview of features, differences from other Arduino boards, and why choose the Nano
Nguyen, Klemens
Paperback
$8.39
Solving problems using logic gates: Practical circuit designs for everyday solutions
Nguyen, Klemens
Paperback
$8.39
Solving problems using electronic circuits: Ready-made solutions to improve circuit design and optimization efficiency
Nguyen, Klemens
Paperback
$8.39
Series, parallel and series-parallel circuits.: Diagrams, calculations, ready-made formulas, explanations.
Nguyen, Klemens
Paperback
$9.32
Automate to elevate: VBA secrets for accountants: Unlocking Excel's potential for accounting wizards
Nguyen, Klemens
Paperback
$14.39
25 Google Sheets for practitioners.: Detailed instructions how to step-by-step create and customize Apps Script.
Nguyen, Klemens
Paperback
$8.39
Modern Excel Automation: Migrating VBA Macros to Office Scripts and Power Automate
Nguyen, Klemens
Paperback
$10.66
Excel Automation at Scale: Advanced VBA and Office Scripts for Business Solutions
Nguyen, Klemens
Paperback
$9.32
Office Scripts + OpenAI for Data Enrichment: (product descriptions, sentiment, summaries)
Nguyen, Klemens
Paperback
$20.39
25 Office Scripts for Busy Excel Users: Real-World Automations You Can Copy, Customize, and Deploy Today - No VBA Needed
Nguyen, Klemens
Paperback
$19.19
ChatOps with Office Scripts: Send Adaptive Cards from Excel to Teams - Automate Approvals, Polls, and Forms without Code
Nguyen, Klemens
Paperback
$20.39
Copilot-Generated Office Scripts: Prompt, Tweak, Ship - The End-to-End Guide to AI-Driven Excel & Power Automate Workflows
Nguyen, Klemens
Paperback
$20.39
AI-Powered Word: Automate Documents, Workflows & Business Tasks with Office Scripts and Power Automate
Nguyen, Klemens
Paperback
$20.39
100 Office Scripts for Excel Online: Real-World Automations for Business, Finance, and Productivity
Nguyen, Klemens
Paperback
$20.39
Google Documents for practitioners.: Detailed instructions how to step-by-step create and customize Apps Script.
Nguyen, Klemens
Paperback
$8.39
Also in
Programming
Interactive Theorem Proving and Program Development: Coq'art: The Calculus of Inductive Constructions
Castéran, Pierre
Bertot, Yves
Hardcover
$194.60
Seven Databases in Seven Weeks: A Guide to Modern Databases and the Nosql Movement
Perkins, Luc
Redmond, Eric
Wilson, Jim
Paperback
$63.29
The Legend of Zelda(tm) Tears of the Kingdom - The Complete Official Guide: Collector's Edition
Piggyback
Hardcover
$42.74
Python Crash Course, 3rd Edition: A Hands-On, Project-Based Introduction to Programming
Matthes, Eric
Paperback
$44.99
Crisis Engineering: Time-Tested Tools for Turning Chaos Into Clarity
Nitze, Marina
Weaver, Matthew
Dickerson, Mikey
Paperback
$18.99
Accelerate: The Science of Lean Software and DevOps: Building and Scaling High Performing Technology Organizations
Kim, Gene
Forsgren Phd, Nicole
Humble, Jez
Paperback
$20.89
Vibe Coding: Building Production-Grade Software with Genai, Chat, Agents, and Beyond
Kim, Gene
Yegge, Steve
Paperback
$30.40
Embedded Systems with ARM Cortex-M Microcontrollers in Assembly Language and C: Fourth Edition
Zhu, Yifeng
Paperback
$86.88
The Legend of Zelda(tm) Tears of the Kingdom - The Complete Official Guide: Standard Edition
Piggyback
Paperback
$28.49
I Have an App Idea: The Essential Guide to Building an App Without Tech Skills
Spann, Amanda
Paperback
$17.05
Fundamentals of Software Architecture: A Modern Engineering Approach
Ford, Neal
Richards, Mark
Paperback
$75.99
AI Projects with Raspberry Pi: High-Performance Artificial Intelligence for Robotics, Security, Home Automation, and Vision
Hattersley, Lucy
Jepson, Brian
Paperback
$21.84
The Manager's Path: A Guide for Tech Leaders Navigating Growth and Change
Fournier, Camille
Paperback
$37.99
Make: Electronics: Learning by Discovery: A Hands-On Primer for the New Electronics Enthusiast
Platt, Charles
Paperback
$33.24
The Devops Handbook, 2nd Edition: How to Create World-Class Agility, Reliability, & Security in Technology Organizations
Kim, Gene
Humble, Jez
Debois, Patrick
Paperback
$36.10
Building Applications with AI Agents: Designing and Implementing Multiagent Systems
Albada, Michael
Paperback
$75.99
The Developer's Guide to AI: A Field Guide for the Working Developer
Orshalick, Jacob
Reghunadh, Jerry M.
Thompson, Danny
Paperback
$56.99
Cracking the Coding Interview: 189 Programming Questions and Solutions
McDowell, Gayle Laakmann
Paperback
From $24.99
The New AI Cold War: Liberty vs. Tyranny in the Age of Machine Empires
Maginnis, Ltc Robert L.
Paperback
$31.83
Learning Web Design: A Beginner's Guide to Html, Css, Javascript, and Web Images
Robbins, Jennifer
Paperback
$75.99
The Staff Engineer's Path: A Guide for Individual Contributors Navigating Growth and Change
Reilly, Tanya
Paperback
$43.69
Software Architecture: The Hard Parts: Modern Trade-Off Analyses for Distributed Architectures
Sadalage, Pramod
Ford, Neal
Richards, Mark
Paperback
$75.99
SQL QuickStart Guide: The Simplified Beginner's Guide to Managing, Analyzing, and Manipulating Data With SQL
Shields, Walter
Hardcover
$33.24
Linux Basics for Hackers, 2nd Edition: Getting Started with Networking, Scripting, and Security in Kali
Occupytheweb
Paperback
$37.99
The Official Raspberry Pi Handbook 2026: Astounding Projects with Raspberry Pi Computers
Makers of Raspberry Pi Official Magazine, The
Paperback
$23.74
The Pragmatic Programmer: Your Journey to Mastery, 20th Anniversary Edition
Thomas, David
Hunt, Andrew
Hardcover
$54.99
Generative AI Design Patterns: Solutions to Common Challenges When Building Genai Agents and Applications
Lakshmanan, Valliappa
Hapke, Hannes
Paperback
$75.99
Forecasting: Principles and Practice, the Pythonic Way
Hyndman, Rob J.
Athanasopoulos, George
Paperback
$76.00
Observability Engineering: Achieving Production Excellence
Miranda, George
Majors, Charity
Fong-Jones, Liz
Paperback
$66.49
Head First Design Patterns: Building Extensible and Maintainable Object-Oriented Software
Robson, Elisabeth
Freeman, Eric
Paperback
$75.99
Frictionless: 7 Steps to Remove Barriers, Unlock Value, and Outpace Your Competition in the AI Era
Noda, Abi
Forsgren, Nicole
Paperback
$33.74
The Return on AI: From Promise to Profit in the Age of Intelligent Business
Sawhney, Mohanbir
Mittal, Ashwin
Paperback
$18.69
Arduino Programming for Beginners: A Comprehensive Beginner's Guide to Learn the Realms of Arduino Programming from A-Z
Protosmith, Ada
Paperback
$18.99
Building AI-Powered Products: The Essential Guide to AI and Genai Product Management
Nika, Marily
Paperback
$42.74
Concrete Mathematics: A Foundation for Computer Science
Patashnik, Oren
Knuth, Donald
Graham, Ronald
Hardcover
$107.99
Grokking Algorithms, Second Edition: An Illustrated Guide for Programmers and Other Curious People
Bhargava, Aditya Y.
Paperback
$62.49
Debugging: The 9 Indispensable Rules for Finding Even the Most Elusive Software and Hardware Problems
Agans, David J.
Paperback
$18.99
Learning Generative AI Tools for Excel: Speed Up Your Everyday Tasks with Microsoft Excel, Copilot, Chatgpt, and Beyond
Duca, Angelica Lo
Paperback
$56.99
Learning Domain-Driven Design: Aligning Software Architecture and Business Strategy
Khononov, Vlad
Paperback
$62.69
Computer Science from Scratch: Building Interpreters, Art, Emulators and ML in Python
Kopec, David
Paperback
$47.49
The Software Architect Elevator: Redefining the Architect's Role in the Digital Enterprise
Hohpe, Gregor
Paperback
$62.69
Python Programming for Young Coders: A Hands-On, Project-Based Introduction to Coding for Beginners, Kids, and Teens
Pandey, Anand
Paperback
$20.57
Learning Php, MySQL & JavaScript: A Step-By-Step Guide to Creating Dynamic Websites
Nixon, Robin
Paperback
$56.99
Software Engineering at Google: Lessons Learned from Programming Over Time
Manshreck, Tom
Wright, Hyrum
Winters, Titus
Paperback
$62.69
Articulating Design Decisions: Communicate with Stakeholders, Keep Your Sanity, and Deliver the Best User Experience
Greever, Tom
Paperback
From $17.99
Living a Jewish Life, Revised and Updated: Jewish Traditions, Customs, and Values for Today's Families
Diamant, Anita
Cooper, Howard
Paperback
$21.84
Prompt Engineering for Llms: The Art and Science of Building Large Language Model-Based Applications
Berryman, John
Ziegler, Albert
Paperback
$75.99
Pro C# 10 with .Net 6: Foundational Principles and Practices in Programming
Japikse, Phil
Troelsen, Andrew
Paperback
$56.99
Adobe Photoshop, 2nd Edition: A Complete Course and Compendium of Features
Laskevitch, Stephen
Paperback
$52.20
Kubernetes in Action, Second Edition: Deploying and Managing Containers and Cloud-Native Applications
Conner, Kevin
Luksa, Marko
Paperback
$87.49
Spies, Lies, and Algorithms: The History and Future of American Intelligence
Zegart, Amy B.
Paperback
$21.80
Site Reliability Engineering: How Google Runs Production Systems
Murphy, Niall Richard
Jones, Chris
Beyer, Betsy
Paperback
$56.99
Ruined by Design: How Designers Destroyed the World, and What We Can Do to Fix It
Monteiro, Mike
Paperback
$23.74
Electronic Music and Sound Design - Theory and Practice with Max 9 - Volume 1 (Fifth Edition)
Cipriani, Alessandro
Maurizio, Giri
Paperback
$76.85
Designing AI Interfaces: Design Principles for Creative and Autonomous AI
Macfadyen, Louise
Paperback
$75.99