Profile cover photo
Profile photo
Bigger Don
7 followers
7 followers
About
Posts

Post has attachment
Spell Checking Protected Worksheets
The Problem When a worksheet is protected (locked) the Spellcheck feature is unavailable, even for unlocked cells.  When the purpose of locking is to protect all data this makes sense.  However, when the purpose is to have the user add information to a form...
Add a comment...

Post has attachment
Weekdays in a month.
The Opportunity How many days in a month?  showed following table, created using the EOMONTH() function, plus NOW() and a bit of formatting. This is fine, but most organizations think in terms of weekdays.  Therefore, the following was created by hiding 3 c...
Weekdays in a month.
Weekdays in a month.
bigdon-in-vbaland.blogspot.com
Add a comment...

Post has attachment
How many days in a month?
What's an EOMONTH? Recently I saw a post referenced in an email that mentioned the EOMONTH() function.  Given a date, plus the number of months before or after that date, it returns the last day of that month. =EOMONTH(StartDate,MonthOffset) For more, here ...
How many days in a month?
How many days in a month?
bigdon-in-vbaland.blogspot.com
Add a comment...

Post has attachment
Intersect Error: Are you kidding me?
Introduction This is a rant.  There is useful information in it.  (Don't get me started on the inanity of the phrase "useless information"!) Today I was working on a project.  Many of my projects go this way: Work on it a little each month as that reporting...
Add a comment...

Post has attachment
Been busy...tale of two clients
Where have I been? For the last 3 months I've been heads down on a project while still holding down a 25% commitment to other duties.  Meanwhile, the usual family and household duties kept me busy, too. I had thought about trying to write during my few hour...
Add a comment...

Post has attachment
How To: Late Bind (2): Existing or New Instance
Introduction In  How To: Late Bind , the ability to either bind to an existing
instance of or a new instance of another "foreign" Office
application, e.g. binding an Excel project to an instance of Word, was covered. What was not included
was the ability to...
Add a comment...

Post has attachment
How To: Late Bind
UPDATED June 26, 2013 Because of some discoveries that came with experience, this post has been modified and re-published.  In essence, the discovery is that there were some untested assumptions about the consistency of CreateObject() and GetObject() for al...
Add a comment...

Post has attachment
How To: Late Bind (2): Multiple Foreign Instances
Introduction How To: Late Bind provided the code needed to late bind to foreign Office applications, e.g. Word while working in Excel.  This included creating a new instance or attaching to an open instance.  What it did not address was cases where For perf...
Add a comment...

Post has attachment
Remote Copy and Paste, version 2 (Optional Paste Special) ...Part 1
Introduction In Remote Copy and Paste, version 1, I introduced the problem, i.e. copy-and-paste data then return to (or never leave) a worksheet.  In that post I provided a userform and code to do just that. In this post I consider the requirements of full-...
Add a comment...

Post has attachment
Updating a Date field to Today
A fun read... Recently, thanks to an email from Chandoo.org, I read a Today() ain't so bad... at Daily Dose of Excel.  It discussed, with a nice bit of humor, the need to add an effective date to a work sheet with what we used to call this "Idiot Proofing"....
Add a comment...
Wait while more posts are being loaded