“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 expert’s VBA library to get you off the ground (without the hassle of researching 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 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 these tricky instructions

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 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 object model, I rarely get the simplest 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 to write operational macros, 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 mouse movements and keystrokes in Excel to VBA is not so straightforward. There are VBA syntax nuances difficult to know and intuit for the macro newcomer, even for experts.

For example, copying and pasting a range doing a literal translation of the mouse movements leads to this cumbersome and slow way…

ActiveSheet.Range(“A1:D22”).Copy
Workbooks(“Target”).Range(“A1”).Select
ActiveSheet.Paste

…or to this other crappy way…

Selection.Copy
Windows(“Target”).Activate
Range(“A1”).Select
ActiveSheet.Paste

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 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.

Also, having the essential piece of VBA code at hand is key for having a good VBA learning experience.

If you already understand VBA, seeing 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+ indispensable 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.

John,

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!

Dave Fields


Hi John,

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.

Thanks

Andy Traynor

John,

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)

Hi John,

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!

Best regards,

Barry

Barry Lawson

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 $47 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?

If you enroll today, you get access to this foundational information, for only…

USD 47.00

IMPORTANT NOTICE: I am testing the price (it will surely go up not down). Grab my new program at this introductory low price.

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
  • 11+ downloadable Excel macro enabled workbooks loaded with more than 100 operational macros you can run, run step by step, tweak them to your needs, etc.
  • 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!

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.

Click Here To Discover The Most Essential Pieces Of VBA Code You Will Ever Need To Write Your Own Macros

Delivered instantly as a members only website and in .xlsm, .zip format, via a download page.

ccbadge

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.

60-day-money-back-guarantee

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.

Thanks!

jf-email-signature

 

 

 

 


FAQ

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?

Click Here To Discover The Most Essential Pieces Of VBA Code You Will Ever Need To Write Your Own Macros

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.

Click Here To Discover The Most Essential Pieces Of VBA Code You Will Ever Need To Write Your Own Macros

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.

Click Here To Discover The Most Essential Pieces Of VBA Code You Will Ever Need To Write Your Own Macros

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?

Excel 2007+

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.

Click Here To Discover The Most Essential Pieces Of VBA Code You Will Ever Need To Write Your Own Macros

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: john@wizdoh.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.