Beyond Excel: VBA and Database Manipulation:

January, 2011

1

January 27, 2011  9:50 AM

Animating Your Company’s Logo in Excel

Craig Hatmaker Craig Hatmaker Profile: Craig Hatmaker

This post shows how to animate a logo in Excel using VBA.  (Click here to download code)

Preview:
  Bookmark and Share     2 Comments     RSS Feed     Email a friend

January 18, 2011  5:28 PM

Debug Your Data with Conditional Formatting

Craig Hatmaker Craig Hatmaker Profile: Craig Hatmaker

(By Guest blogger Yoav Ezer) Many times when a workbook is crammed full of numbers, your data can be difficult to read. This is bad enough when you are sure the data is correct, but If you are supplied a spreadsheet that contains potential errors you really want to be able to detect them so they...


January 13, 2011  2:00 PM

Dynamic Named Ranges in Excel – Overcoming Shortcomings

Craig Hatmaker Craig Hatmaker Profile: Craig Hatmaker

A couple of months ago, Guest blogger Yoav Ezer posted a piece including the concept of Dynamic Named Ranges (see Strategies for Speeding Spreadsheets).  Dynamic Named Ranges...


1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: