Monthly Archives: December 2010

Is Excel 2010 Kinda Fragile ?

I have once again run into a major probem in Excel 2010 related to doing major surgery on a large file and ending up with it being unwilling to Save and requiring me to perform some serious “sleight-of-hand” to save … Continue reading

Posted in Uncategorized | Tagged , , , , | 4 Comments

I Didn’t Follow My Own Rules

I am currently involved deeply in a project that replaces an exisiting spreadsheet-based production-planning system.  The existing user-maintained document is one of the most dangerous spreadsheets I have ever seen. But when contacted to help on this I made a terrible … Continue reading

Posted in Uncategorized | Tagged , , , , , , , | 5 Comments

Errata2

I have always worried about giving code advice here for the simple reason that I might be misleading people with wrong, or inefficeient code or code that I thought worked in all conditions but subsequently could be proven otherwise. Well … Continue reading

Posted in Uncategorized | Tagged , , , | Leave a comment

Putting Tables To Work In Excel 2010 – Errata

A week or so ago I included some code in a Blog about using Tables in Excel 2010.  In that blog I included some code that, among other stuff, was supposed to clear all the existing rows of data in … Continue reading

Posted in Uncategorized | Tagged , , , | 9 Comments

I Think I’m In Switzerland

Here’s a picture JUST taken out our bedroom window: So beautiful !!  60+ cms in the last two days with more to come (and then rain on Friday darn it 😦   ) So we have School Snow Days and extra … Continue reading

Posted in Uncategorized | Tagged , , , , | 5 Comments

Observations On A New Bathroom

We had a flood in my house when I was in Europe last month..  Apparently the toilet overflowed in the upstairs bathroom when my grown son was here alone (apparently :-)) and it destroyed the upstairs bathroom, the hall (which … Continue reading

Posted in Uncategorized | Tagged , , , , , , | Leave a comment