excel

Debug Your Data with Conditional Formatting

(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...

Dynamic Named Ranges in Excel – Overcoming Shortcomings

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...

Chart Drill Down

PivotChart Drill DownThis seems so basic to me that I was not surprised Googling "Drilldown Excel Chart" shows lots of interest out there.  But the implementation is so simple that I was very surprised Googling "Drill Down Excel Chart"...

Controlling the Cursor: Find_Unlocked_Cell

Today's little routine was repeated all throughout Position_Cursor_In_Data (See previous post).  It's a simple little routine with not much to talk about except one little trick:

v = Intersect(ActiveWindow.VisibleRange, Selection)

Controlling the Cursor: Position_Curosr_In_Data

The last few posts covered Worksheet_Change and Worksheet_SelectionChange events.  Both rely on a function called Position_Cursor_In_Data.  Position_Cursor_In_Data's Job is...

Back to Controlling the Cursor

This post returns to controlling the cursor in update spreadsheets. As the user positions the cursor on the spreadsheet, we want to have it jump over 'locked' cells to the next 'unlocked' cell.  The words 'locked' and 'unlocked' are quoted because we aren't exactly using Excel's notion of...

Strategies for Speeding Spreadsheets

By guest contributor: Yoav Ezer

NOTE: This post provides an example spreadsheet: accelerating-excel.xlsm.  Due to concern for your system's security, macro enabled...