“Are You Willing To Follow More Than 150 Indispensable Macros To Do The Most Wanted Excel Things In VBA, And Start Beating The Application And Those Arbitrary Deadlines?”
“Finally revealed! An Excel expert’s done-for-you VBA macro library to get you off the ground (without the hassle of researching, figuring out and testing these tricky macro programming instructions)”
From: John Franco, Excel author
At my desk, Tuesday, 8 AM
Dear Excel friend,
If you want to use macros to finally break free from the chains of ‘time & energy sucking projects’ but the lack of time to figure out the exact VBA syntax, the complex syntax itself and the lack of relevant VBA examples, have always prevented you from getting started, then this is the most important message you will ever read…
…because today you will discover that getting started with macros for being much ahead of deadlines is not complicated if you have the essential VBA code at hand.
My story with finding the tricky VBA code for my macros
I have a confession…
…learning and using VBA have given me freedom and professional prestige beyond all my wildest visualizations but…
…still today, with all my understanding of the VBA language and macro programming techniques, I don’t know how to do all the most basic Excel things in VBA. I tend to postpone researching the exact syntax for doing the most simple Excel tasks because the VBA syntax is quite unpredictable at times…
…yes, with all my understanding of the Excel object model, I rarely get the simplest VBA code version right. For example, to select the entire sheet, I would write ActiveSheet.Range(“A1:XFD1048576”).Select not Cells.Select.
I prefer stealing proven pieces of VBA code from a proven resource such as my code snippets library (gathered over the years of trial-and-error and research) or from a trusted expert’s macro.
And it’s ashaming to acknowledge that many of the essential VBA pieces I have developed myself have been acquired by mere accident. I mean, I found them while I was not searching for them.
I also prefer recording a macro but the crappy code always need polishing and I am lazy to strip the garbage code away.
Whether you are starting out with macros or if you are a seasoned VBA expert, you and I know that when one has already understood VBA or try writing macros that are operational, our craving is no “give me more VBA understanding” but “give me the damn macro code PLEASE”.
Unpublicized VBA nuances
The truth is that understanding VBA and the Excel object model won’t empower you to code the most basic tasks because translating your ideas, mouse movements and keystrokes in Excel to VBA is not so straightforward. There are VBA syntax nuances difficult to know and see for the macro newcomer, even for macro experts.
For example, copying and pasting a range doing a literal translation of the mouse movements leads to this cumbersome and slow way…
…or to this other crappy way…
But the simplest and most professional way is this one:
Worksheets(“Source”).Range(“A1:D22″).Copy Destination := Worksheets(“Target”).Range(“A1”)
How one finds an essential piece of VBA code?
It’s an art and is also a lot about stealing pieces of proven-and-done-for-you VBA code ;)
The myth of macro inspiration…
Is it the current book, sheet or the current window? Is it Range(“A1:XFD1048576”) or simply Cells? Researching and testing VBA is tricky and requires a lot of trial and error (and imitation). This is true because VBA is an extensive language and has many hidden workarounds for the newcomers and even experts like me.
Even if one makes a coding decision, the syntax is prone to errors and one ends up doubting our judgment.
If our macro module is blank, the source of every new piece of the rightful code is unknown to us. And each potential VBA solution brings fear because one doesn’t know if it will work.
Sometimes, what we need is a bit of rightful VBA code to point us in the right direction or simply a little kick in the butt to overcome the initial resistance of creating something from scratch.
If you are getting started with macros, knowing the exact syntax to do the most basic Excel things in VBA is the key to getting your first macros running without the cumbersome programming creative process.
If you are able to write your own macros, having the exact syntax to do the most basic Excel things in VBA is the key to completing your macro projects and make your macros fully operational.
Also, having the essential piece of VBA code at hand is key to having a good VBA learning and coding experience.
If you already understand VBA, seeing new and relevant examples of operational macros can open your eyes to new possibilities and keep you inspired for learning more.
I have synthesized a library of these essential Excel VBA snippets over the years and wanted to share it with those who prefer the easy way to getting started with macros.
Announcing The comprehensive library of essential VBA code…
How To Do More Than 150 Fundamental Excel Tasks In VBA
A gallery of 150+ fundamental macros to do the most wanted Excel things
This is the “insider” VBA library John wishes was around when he was starting out with macros earlier in his career. Learning even one or two of these essential VBA techniques would have short-cut his own success by… oh… five… maybe five years. Probably more.
I have just been able to look over your program quickly, but it looks good!! This is the type of VBA foundation building information that I believe many of us need.
Thank you John, this is going to be great!
Just had a quick run through the various modules, this is exactly the type of info I have been looking for.
Keep up the great work.
I got your 150 Fundamental Excel Tasks In VBA course today, and am reading through some of the macros with delight.
I have been able to use the information from “How To Do More Than 150 Fundamental Excel Tasks In VBA”. I, like so many others just jumped into VBA without ever really getting a foundation and the course has provided me with many of the foundation questions I have had and I have a better understanding of VBA because of it.
Dave Fields (yes :) he sent me another email)
Yep, so far, so good thanks.
I haven’t had as much time to run through it as I would like but what I have seen is exactly what I’m looking for. Having bought a few of your courses in the past, I’m not surprised that my VBA learning expectations have been exceeded. The materials are exactly at the level I’m looking for and the way they are presented will make it easy for me to apply the learnings to my job.
I’m looking forward to spending time developing my vba knowledge and skills.
Keep up the good work!
Warning: Why you should not get this expert’s VBA library
The 150+ relevant examples of this expert’s VBA library are intended to help you get off the ground with macros in minimum time and to complement your VBA learning. This library is not designed to bypass the study of VBA fundamentals.
If you think you can count solely on using these 150+ essential macros to get the full benefits of macros, then please abandon this page now.
Included in this simplified VBA code library are VBA techniques many Excel users never get it… such as:
Module 1 – How to move data between cells, sheets, and workbooks
- How to copy data from one range to another sheet
- How to copy data to a new workbook and save it
- And much more!
Module 2 – How to write formulas in cells and ranges
- How to write a COUNT formula
- How to write a SUMIF formula
- How to write a SUM formula
- How to copy formulas down to the last row
- And much more!
Module 3 – How to merge cells, sheets, books, etc.
- How to merge two cells that match certain criteria
- How to merge many sheets
- How to merge books in a folder
- And much more!
Module 4 – How to open, save and export workbooks and sheets
- How to save a book with a different name
- How to close all open books
- How to open the books in a folder
- How to send the active sheet as pdf by email
- How to save with a custom stamped name
Module 5 – How to do Vlookups
- How to write a Vlookup formula in Excel
- How to use the power of Vlookup inside a macro (without writing any formula)
- How to write an Index & Match
- And much more!
Module 6 – How to print
- How to print the books in a folder
- How to print the selected sheets
- How to print a range of pages of the active sheet
- And much more!
Module 7 – How to create and set up PivotTables
- How to create a PT from scratch
- How to rename the PT totals
- And much more!
Module 8 – How to create and set up charts
- How to create a line chart
- How to create a pie chart
- How to set the chart title
- How to set the chart axes
- And much more!
Module 9 – How to format cells and ranges
- How to set the cell font styling
- How to set the range borders
- How to merge and unmerge cells
- How to set the cells number formatting
- And much more!
Module 10 – How to loop (how to iterate through cells, books, charts, pivottables, etc)
- How to loop through the cells of a column
- How to loop through the cells of a row
- How to loop through books, charts, etc
- And much more!
Module 11 – How to work with cells and ranges
- How to hide columns, rows, etc
- How to write variable values to cells
- How to store a cell value in a variable
- And much more!
Module 12 – How to get information about cells and ranges
- How to store a range in an object
- How to find the last used row
- How to get the size of a range
- How to enter to the next occupied cell
- And much more!
Module 13 – How to create and set up UserForms
- How to create an User form
- How to add the most common controls (text boxes, command buttons, etc.) to user forms
- How to send user form data to the last row of the active sheet
- How to send user form data to the last row of any given sheet
- And much more…
Here’s how to get this foundational material our community needed!
With this practical macros program, you will stop wasting hundreds of dollars combined on VBA books and VBA programs you cannot put to use because they never give you the exact VBA code you need to do the most basic daily Excel tasks and functions.
And if you consider you can get a better job or a promotion when you get off the ground and start doing the most basic Excel things in VBA, the price of this material is ridiculous.
I really mean it…
…with a $97 product, you can add a 10%, 20%+ increase to your salary because VBA is a highly in-demand skill in today’s data-driven economy and your increased self-worth will be reflected in the promotions and bonuses you are going to get or in the new and better jobs you can prospect and get.
What does a 10% increase mean to you, dear friend? Hundreds even thousands more in your pocket each month?
And if you are VBA freelancer or looking to become one, these done-for-you macros will help you complete projects faster and take new projects with confidence. Just one macro gig can put hundreds of dollars in your pocket.
If you enroll today, you get access to this foundational and insider VBA information, for only…
What do you get?
In a nutshell, you get private access to the Download area where you can explore all the essential VBA snippets, download all the VBA workbooks, bonuses and updates for a lifetime, and email support for 6 months.
- Access to an easy-to-navigate membership site with a library of more than 150 macros to do the most wanted Excel things in VBA
- 13+ downloadable Excel macro-enabled workbooks loaded with more than 150 operational macros you can run, run step by step, tweak them to your needs, etc.
- 13+ downloadable PDF modules with a clickable table of content to easily navigate the macros
- A customer form to submit your own VBA snippet ideas. I will consider the most common routines and requests and upload the code and workbooks to the exclusive members’ area
- Lifetime access to updates: new snippets submitted by others, new snippets by me
- and so much more!
And you also get…
Bonus # 1- Excel Object Model Blueprint
You and I know that without having the big picture of the Excel object hierarchy, finding the exact syntax for our macros or understanding the syntax is cumbersome. And we also know that Microsoft has wiped out this information from its help system. You don’t get a map view of the objects anymore but only an encyclopedia of links where one never sees the big picture.
I knew this material was crucial to macro success and compiled it before it disappeared!
I have synthesized everything in a convenient pdf you can easily explore, zoom in, and zoom out.
If you want to immediately have clarity about the whole Excel object model, then this rare pdf is for you!
In this practical and hard-to-find VBA syntax blueprint, you will learn:
- What are the main Excel objects and how to access them in a macro
- What are the available collections you can use in your loops
- Why some macros look the way they do
- How to access any aspect of Excel using VBA code
- and much more
You get this secret VBA syntax building blueprint for free if you order the program ‘How To Do More Than 150 Fundamental Excel Tasks In VBA’.
Bonus # 2 – Dynamic Macro Recording Formula
This practical video lesson reveals the 5 VBA dynamic techniques to easily make your recorded macros work for variable array size and conditions.
If you want to reuse your recorded macros, then this macro recording formula is for you.
Includes a VBA workbook practice file!
Bonus # 3 – Recorded Macro Performance’s Optimization Formula
You know the macro recorder fills your macro with garbage (unnecessary selections, scrolling, sheet shifting, etc.) and they become painfully difficult to edit and adapt to your situation.
And recorded macros are slow and silly.
Learn how to take your recorded macros to an optimal level. This practical video lesson reveals a 3-step VBA optimization formula to clean all the unnecessary VBA code and improve your recorded macros’ performance, readability, and usability.
If you want to synthesize your recorded macros and make them perform at their best, then this macro recording formula is for you.
These VBA bonuses are worth $150+
Grab HDFTVBA and the bonuses now if you are planning to become free from repetition today and in the years to come.
If you’re serious about using macros to control the data cleaning, dashboard creation, sheet comparison, etc. tasks, when you need to repeat them again in the future, then go ahead and click the button below.
Delivered instantly as a members-only website and in .xlsm, .zip format, via a download page.
With a small investment, Excel Macros will pay you back again and again.
If you don’t learn macros, you will keep redoubling your time and effort for completing assignments.
You risk nothing
If within 60 days of purchase, you follow and implement the essential VBA pieces of code and cannot write your own macros for automating your work, or if you simply didn’t like the material, just ask a refund and you will get your money back, no questions asked.
I have been selling information products online since 2011 to thousands of professionals from around the world.
Just contact us (use the subject “refund”). I will take care of it.
Enroll now and start learning how to do the most basic Excel things in VBA.
Can I google these macros?
Searching and finding are two different things. You can google all your needs but can you actually find what you are looking for?
Sometimes, one cannot find the exact search words to find the exact piece of code. At other times, the solutions are provided by developers, with advanced techniques that you don’t understand yet and with more information than you need at your current stage of understanding.
And the solutions are scattered all over the place, in different blogs, forums, etc., with different styles and hidden agendas. But what you need is everything in one single location, curated and readily available.
And the truth is that there are many resources on the net but is there one that is the best to find basic VBA code to get you off the ground?
Who is this library for?
This library of essential pieces of VBA code is for you if you are getting started with macros and want to have a reference source of VBA code to perform the most basic functions.
You will love this library if you want plenty of relevant VBA examples.
This library is also for you if you don’t know what property or method to use for certain tasks and want to see how the most common objects are used for doing the most essential Excel tasks.
Even if you are an expert, you might find some surprises to increase your VBA arsenal of techniques. If you find increasing challenging scenarios and you are constantly improving, you know that there’s never enough of VBA techniques to dispose of.
I don’t understand VBA yet, can I use the pieces of code to create macros?
You will get the most of this material if you already understand the fundamentals of VBA. But even if you have never written any macro, you can quickly use the pieces of VBA code to get some practical results that will get you off the ground, such as closing all the open books or opening all the books in a folder, creating a line chart for your weekly report, etc.
Also, this essential VBA library is the perfect companion if you are already started learning macros or if you plan to do it in the future.
Do we have access to the program for a lifetime?
Yes, you can download everything to your computer and keep it yours forever. You have lifetime access to the members’ area to download the updates.
What Excel version do I need?
The Excel workbooks are saved as macro-enabled books (.xlsm)
If I am not getting correct results, can I send my practice to someone for comments/review? Is help only available through email or is it possible to chat or talk to someone?
You have 6 months of email support. You can open a support ticket at any time during this period. You will get an answer by email in the next 24 hours.
Can I purchase the program for myself and my team?
Yes, you can purchase for multiple users and take advantage of my group discount. Please email me with the number of students and I can provide a discounted price: email@example.com
Disclaimer: ClickBank is the retailer of products on this site. CLICKBANK® is a registered trademark of Click Sales, Inc., a Delaware corporation located at 917 S. Lusk Street, Suite 200, Boise Idaho, 83706, USA and used by permission. ClickBank’s role as retailer does not constitute an endorsement, approval or review of these products or any claim, statement or opinion used in promotion of these products.