code execution vba

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

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!

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!

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

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!

 

 

 

what is business casual?

What is Business Casual?

What Is Business Casual? My Personal Intro

15 years ago I was offered my dream job (at the time).  It was exciting, but working through the logistics was somewhat stressful.  I would be attending training for my first two weeks, far from home.  “Please arrive prior to 8 AM on June 24th.  The dress code is business casual.”  Huh?  After getting other important details, I hung up with the HR rep and immediately walked over to my closet.  What on earth does business casual mean?

It was three weeks before I started my very first corporate job, and I was so stressed about “what to wear”.  At my former job as a store manager, I wore a uniform shirt with black pants and black shoes every single day.  I never had to put any thought into it.  As long as my clothes were clean and wrinkle free, I was good to go.

As I surveyed my closet, I quickly realized that I didn’t have too many “nice” clothes, definitely not any that I would have wanted to show up wearing on my first day.  Everything was way too casual.  A nice assortment of sundresses and lacy tank tops were the best options.  Definitely not appropriate though, because it was a summer wardrobe.  I loved to hang out at the beach or in a friend’s back yard.  Everything was pretty low cut or skimpy.

Time to Shop (Woohoo!)

For what though?  What on earth would I be shopping for?  Many individuals in various positions and professions are provided with a clear definition of the expected dress for work, such as a uniform, suit or dress suit, costume or OSHA required equipment, e.g., steel toe boots and a hard hat.  I feel those are the easiest to dress for.

I started asking around and quickly found that there tends to be quite a bit of latitude in the business casual realm and this can cause quite a bit of stress for someone who is starting a new job.  In one organization, business casual can mean a button down and tie with pressed slacks is the daily expectation, whereas another organization will call for a nice golf polo and khakis.

The Corporate Handbook

I called the HR rep back and asked if they had a dress code guide.  He said it was in the corporate handbook he had just put in the mail for me.  Once it arrived, I quickly thumbed through and found the section on attire.  The rules laid out in the corporate handbook were very similar to my high school dress code and pretty obvious to me.  No denim, spaghetti straps, bare midriffs, sneakers, open toed shoes, etc.  Unfortunately, nothing was clearly defined beyond that. Were khakis okay?  Could I wear a button down shirt or polo?  I knew that I wanted to fit in, especially being a very young, newbie professional. I definitely did not want to leave a bad impression simply because I was dressed inappropriately.

Other Sources

A trip to the local bookstore allowed me to browse through a few books, but I found that they were outdated and their suggestions applied more to the headquarters folks in the company, where everyone wore a suit or dress suit everyday.  There was literally a two page chapter on business casual dress in one of the books.  It was pathetic and frustrating.  Searching on the internet turned up suggestions that ran the gamut.  Some of the outfit suggestions seemed like a better fit for a day at the beach or a night at the bar, than an important meeting with my future management.

Lights, Camera, Action!

In the end, I decided to opt for a very conservative set of outfits for week one.  I was basically following our headquarters dress code, but without the full suit get up. Some button down shirts and a few blouses with black pants.  I added a suit jacket for good measure.  It worked out very well and after a few days of exposure to my new colleagues, I was able to figure out a general expectation and gather good ideas for acceptable attire.

The following weekend, I went out and began to build what would become a nice, flexible wardrobe that I was proud of.

In the coming posts in this section, I will provide some of the guidelines that now I live by when dressing for work.

Please feel free to add your comments and stories below!  Share this with a recent graduate or someone else who’s a corporate newbie.

Save

Dress For Success – A Primer

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.