Tag Archives: VBA

Dutch Treat

Sorry for not blogging lately (as is if anyone actually comes here – actually quite a  few do). I have been busy, busy on a project in Europe while working evenings back in North America. I actually like this double-time … Continue reading

Posted in Uncategorized | Tagged , , , , , , , | 6 Comments

Dynamic Range Names And Charts In Excel 2010

(Update 05/27/11)  Please be advised that there is a more recent post than this that completely negates the need for the technology mentioned in this Post.  It does not mean this is not a Cool solution (IMHO) but it is … Continue reading

Posted in Uncategorized | Tagged , , , , , , , , | 20 Comments

Making Access Forms More Screen Responsive

I am unfortunately one those developers with a policy of “If it ain’t broke don’t fix it.”  Sometimes that’s a good thing but other times that can be a limiter on personal growth. I mean this in the context of … Continue reading

Posted in Uncategorized | Tagged , , , , , , | 1 Comment

Excel Careers

Great post over on friend Simon Murphy’s site about Excel careers (or lack thereof).  Check it out: http://smurfonspreadsheets.wordpress.com/2011/03/21/excel-careers/ Dick

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

What Does The Lack Of Microsoft Office Seminars Mean ?

I just bumped into the SharePoint Conference 2011  on the Internet today ( http://www.mssharepointconference.com/Pages/default.aspx ).  I remember not too long ago that this conference was the Office Developer Conference (maybe 2 years back) and now I see not one reference … Continue reading

Posted in Uncategorized | Tagged , , , , , , , , , | 8 Comments

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

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