Tag Archives: VBA

Dutch Treat

Posted on July 13, 2011 by Biggus Dickus

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

Posted on May 19, 2011 by Biggus Dickus

(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

Posted on April 14, 2011 by Biggus Dickus

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

Posted on March 21, 2011 by Biggus Dickus

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 ?

Posted on February 6, 2011 by Biggus Dickus

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 ?

Posted on December 28, 2010 by Biggus Dickus

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

Posted on December 15, 2010 by Biggus Dickus

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

Posted on December 14, 2010 by Biggus Dickus

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

Observations On A New Bathroom

Posted on December 1, 2010 by Biggus Dickus

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

Putting Tables To Work In Excel 2010

Posted on November 25, 2010 by Biggus Dickus

I was very lucky to be able to develop a major Excel 2007    “Application” shortly after it shipped.  In that file I used the new Structured References that are designed to work with the enhanced Excel “Tables” from that version.  I … Continue reading →

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