Writing a Custom Function
Using VBA, Excel lets you write custom functions that you can call from any cell in your worksheet (You can also call them from macros you create in VBA, but we’ll revisit this later). This feature is attractive when you are currently using a complicated formula to do some work in your spreadsheet, especially when you have to re-use that formula multiple times. I find that it is easier to read through the formula when it written in VBA, rather than a long winding formula in the formula bar of Excel.
So for this post, we’re going to take a look a small custom function I’ve written to find the last day of the month. So let’s go ahead and take a look at this example.
Read More
Difference Between Sub and Function
The difference between when to use Sub and Function in VBA can be confusing. Let’s take a look at some of the differences between the two and when they should be used. Using these two features correctly can greatly increase the flexibility of your designs.
How Often Do You Use Excel Macros?
The second poll on Excel Hints just closed and I’d like to thank everyone who participated. One of my goals is to use these polls to gauge what the readers of Excel Hints are looking for. Which takes us to the most recent poll that just closed today: How often do you use macros?
Read More
Separate Full Name into First & Last Name
Here are two easy formulas that will separate a cell that contains a full name (first and last name format) into 2 cells – one containing the first name and the other containing the last name. To do this we are going to make use of the left, right, len & find formulas.
Recent Difficulty with Email Subscribers
If you subscribed to Excel Hints through email – you may have noticed some recent activity where old posts are being sent out numerous times. I would like to apologize for this and let everyone know that I have been working with Google to correct the problem (For anyone that is interested in the details – apparently Google switched servers last week and has been having some bugs. I believe I have fixed the problem but will be monitoring the feeds manually until it looks good again).
Thanks for bearing with Excel Hints through this temporary setback and thanks again for subscribing to Excel Hints!
John
