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 »

Understanding Dates in Excel

What are Dates? This may seem like a strange thing to ask but, as far as Excel is concerned, dates are numbers. By storing them as such, it gives us the ability to add or subtract days to/from a date,

Read More »