Month: September 2016

code execution vba

Code Execution Has Been Interrupted- VBA Keeps Breaking – Solved!

Posted on by Bb

How to stop code execution has been interrupted error in Excel VBA.

My Excel VBA Keeps Breaking: A “code execution has been interrupted” keeps coming up, but my Code is Not “Broken”

So I have to share this handy trick.  Sometimes when I’m running VBA code in Excel, it starts getting wonky.  The Break/Debug window keeps popping up during execution, for no good reason.  Code execution has been interrupted, over and over.    The code has run perfectly fine in the past, perhaps hundreds of times.  It’s almost as if something is stuck and hanging in the background.  Restarting Excel does no good.  It seems that the VBA interface itself needs a reset, but clicking reset does nothing.

Solution!!

code execution has been interrupted window

When you receive the code execution has been interrupted pop-up,  click Debug.

Then press Ctrl+Pause/Break twice.

Click on the Green Arrow or press F5 to resume.

You should be good to go, as long as there is nothing inherently wrong with your VBA code!

I’m not sure how or why this works,but it does. I think there may be some sort of bug in Excel, so hopefully it will be fixed at some point.  I hope this helps you as much as it has helped me!  Simple solutions sure are the best!

Comment below and let me know if there are other issues you would like me to solve!

Save

Top 5 Copy Paste Functions in Excel – Values, Formatting, Special and More!

Posted on by Bb

Top 5 Copy Paste Functions in Excel – A Detailed Guide

The copy and paste functions in Excel save time and effort, since there’s no need to retype information that already exists.  In  this post,  I will cover and explain the different copy and paste operations that Excel offers.

There are a million reasons under the sun to copy and paste in Excel.  You may want to duplicate information in one column, another sheet or even another workbook.  Perhaps you are copying and pasting data from another source, such as MS Access, your web browser, or a PDF document.  Maybe you are moving data around within a worksheet or workbook.

Copy vs. Cut in Excel

When you select copy within Excel, you are telling the program that you would like to duplicate the information.

When you choose cut in Excel, you remove the data from where it currently exists, and place it elsewhere.

How to Copy

To begin, you must select the data that you would like to copy.  This will move the source data to the clipboard, which is a temporary holding place in the background.

Highlight the data.  To copy using the mouse, right click, and select the copy option.   You may also use the keyboard shortcut – Ctrl + c.  Click in the destination cell.

Paste Options Explained

Copy Paste Special
Copy Paste Menu in Excel

PastePaste – If you would like to paste your data as is, with no changes, right click and select this icon.

Excel ValuesPaste Values – If you’re copying a formula, but only want to paste the results, select this icon, with the numbers.

Excel Paste Formulas Paste Formula – Say you wanted to paste just a formula or set of formulas, you would choose the option with the “fx” in the icon.  Note that depending on what the formula is doing, the result may be different from the original.

Excel Transpose PastePaste and Transpose – The transpose option allows you to change the orientation of your data.  Let’s say you had four items listed vertically.  Using the transpose option would allow you to paste the items horizontally, or vice versa.

Excel Formatting PastePaste Formatting – Excel gives you the option of pasting the formatting only.  If you had some nice shading, or conditional formatting and wanted to copy that, but not modify the formula or data of the target cell or range, then paste formatting would be the option to choose.

Excel Link PastePaste Link – You can simply paste a link to, or reference to the source as a formula or formulas if you are copying multiple cells.  Hint: If you are copying only one cell, by default, the reference will be absolute.  This means that you can move the formula around, but the cell(s) it is pointing to will not change.  When copying multiple cells, the result will be relative references.

 

Save

Save

Save

Save

Save

Microsoft Excel in My Life – How I Learn and Share

Posted on by Bb

My Life with Excel – Learn, Grow, Repeat

Microsoft Excel has been a huge part of my life for over 17 years now.  It is an incredibly powerful application, with so many features and functions that are not fully utilized by the vast majority of users.  It’s amazing how different my creation and application of spreadsheets, formulas, charts and graphs is today, compared with years ago.  Back then, it was absolutely basic Excel for me.  There are certain functions that I have had to learn and relearn, due to some of the great advances in the software.

Microsoft Excel in My Life – Ever changing = Non-stop Learning

I learn something new every week!  My skills have continued to grow exponentially and I rarely have to spend more than a few minutes determining an Excel based solution for the business challenges, problems and opportunities I face on a daily basis.

“The Guru”

Colleagues often refer to me as the Excel guru.  After learning so much from some true gurus in the Excel domain, I feel the title is a bit much for me, but I definitely can (non-humbly, sorry) admit that I’m pretty darn good and well versed in the application.  Coworkers come to me whenever they are stuck, or trying to come up with a new way of doing something.  I even get calls for help from people in other departments, from around the world!  I love to share my wealth of Excel knowledge with anybody and everybody.  I am thrilled when I learn something new.  I’m doubly ecstatic when someone else does!  There are infinite possibilities with spreadsheets these days, when you roll in VBA, Power Query, PowerPivot, PowerBI and Azure!  It’s amazing, and I’m only just beginning to truly harness some of that power.  Everyone who uses Excel should learn about these!

Tutorials and Posts

My plan is to create tutorials and posts as frequently as I can manage.  I only want to provide meaningful content and information, and truly strive to be clear and concise in my delivery.  I welcome your questions and commentary on my posts!  I would love to help and teach as many people as possible.  I may even design a class!  Excel makes life easier!  That’s one of my mantras!

Please let me know if you have questions or feedback in the comment section.  I would love to hear from you!

 

 

 

Dress For Success – A Primer

Posted on by Bb

You are what you wear!

Do you dress for success?  Are you carefully choosing your outfits each day, or do you just grab whatever is clean and throw it on? Your appearance will come before all else when working in a face to face environment.  You can have the very best credentials and tons of experience in your particular field, but if you show up to work looking like you’re ready for a cocktail party, or even worst, a slob, you will likely not be taken very seriously.

 

Dress Codes

The workplace dress code has been a topic of discussion that has come up at every single organization I have been a part of.    I’m all for creativity and expressing individuality, however, there are some unwritten rules when it comes to corporate attire.  Work is not the place for you to show your “assets” off in detail, unless you happen to be a fashion model, dancer, actress, other arts professional or perhaps a bartender, etc.

The industry, company age and size definitely tend to dictate the acceptable work wear.  Older, larger corporations in the banking, oil and publishing industries generally adhere to a very rigid standard.  Suits and ties are the norm.  Newer startups often advertise the lax dress code and casual atmosphere in their job postings.  “Wear flip flops and sweatpants everyday!”

 

Observe Others and Emulate

It’s always helpful to observe employees at a firm or company before and after the interview, so you can get an idea of how formal the dress is.  One rule of thumb is to dress for the job you want, not just the one you have.  To follow this, it’s crucial to observe those who are in the role you are dreaming of.  Sometimes you can look foolish, if there’s a huge difference compared to what your peers are wearing.  In that case, it’s probably best to find some middle ground.  Throw a nice jacket or sweater on, but avoid the whole suit, if your peers are dressed down, while the execs  are dressed to the nines.