SmittyPro - Witticisms, Help, Tutorials and More
Jan
29

Create a Table of Contents in Excel

written by Zack

There has always been a need for a good Table of Contents in Excel. While Word features this natively with its built-in Styles, unfortunately, Excel lacks this functionality due to a host of reasons, which are quite valid. However, we can create a workaround by incorporating some VBA. The following code is an updated version […]

Read More About - Create a Table of Contents in Excel »

Jan
7

Create Outlook email and appointments from Excel with VBA

written by Zack

The power of Microsoft Office is quite undeniable. The premier application of the suite is Excel. The love/hate relationship we have all had with it endures. Often times you may find the need to utilize multiple Office applications from within one another. An extremely common request is to create emails and appointments in Outlook, all […]

Read More About - Create Outlook email and appointments from Excel with VBA »

Apr
25

Excel VBA – How to set a Range variable with a function

written by Zack

So I found myself writing some VBA code in Excel which used some Range variable types, but they were based on finding data in a range, in this case column headers. I didn’t know where the columns might be, but I knew the value the cells would hold. The problem was I didn’t always know […]

Read More About - Excel VBA – How to set a Range variable with a function »

Apr
24

Office 2007/2010 – Getting around the #$%^@! Ribbon

written by "Smitty"

If you’ve upgraded to Office 2007 or 2010 from an earlier version you were undoubtedly as shocked as anyone else when you first opened up your “new” Office applications (and they truly are new aren’t they?) You guessed it, I’m talking about the new “Ribbon” User Interface….. I’m not going to teach you about the Ribbon here, because that could easily be a course in and of itself, but I am going to give you a bunch of resources that will help you adjust to it more quickly.

Read More About - Office 2007/2010 – Getting around the #$%^@! Ribbon »

Microsoft MVP

 

Join In

Tag Cloud

Great Links

Archives

SmittyPro.com

Welcome to SmittyPro.com, your one-stop for solutions concerning anything from beginner to extremely advanced Microsoft Excel issues and programming. Topics covered include Excel, Access, VBA, and (every now and then) some amazing observations or "Smitticisms" that might dumbfound you and send ripples of excitement or intrigue around the world.

Categories

Meta

RSS Top Stories from CNN

Vistor Counter for SmittyPro's Blog