Author: Ken Puls

The best line of VBA ever

Okay, I'll admit that you probably have to be a parent of a young child to agree with this, but here it is: [code]Application.Speech.Speak Target[/code] This all started when I showed my kid how fast the computer could count to

Read More »

Always Refer to the Cell Above

Introduction How many times have you built a table of data, and put totals on it. You ship it out the door, and another user comes along and inserts a new row right before the totals row? If you have

Read More »

Using Styles in Excel – Why and How

What are Styles? A style is pre-defined set of formatting instructions held together in one convenient package. They can be configured to apply one, two or many formatting characteristics, and can be applied to a worksheet cell or range very

Read More »

MVP Summit 2008 – The trip home

For the last time, we were up at 6AM again, this time to catch the ferry home. Boarding was pretty uneventful, really, but part way home we got a message... 5 inches of snow at my inlaws. (They only live

Read More »

MVP Summit 2008 – Friday

Officially, the summit was over.  But we'd booked an extra day, and a few of the Excel guys were still around. We got up at 7AM, for breakfast at Lowell's at 8AM.  (Really slept in!)  Strangely, I never took any

Read More »

MVP Summit 2008 – Thursday

Another day, another 6AM rising for breakfast.  This time it was at the Washington State Trade and Convention Centre, and the breakfast was pretty good.  A full buffet that actually had fruit at it.  The only complaint I have, cause

Read More »

MVP Summit 2008 – Wednesday

Another early morning, another hotel breakfast.  This time eggs in a bagel, with a muffin and an apple.  Again, something to be desired, really. After another bus ride out to Redmond, they threw us in to a session with a

Read More »