Archive for 2008
Monday, November 17th, 2008 16 views
Many people are familiar with the page on binding found on Dick Kusleika's website "Dick's Clicks" which advises the following:
To get the most out of the VBA development environment and still write robust code, you should write the code early bound, but change it to late bound before distributing it. ...
Posted in Excel, VBA | No Comments »
Thursday, November 13th, 2008 144 views
If you ever needed to capture a range, for pasting into a document or email, you'll need to save it as an image first. If so, you might find this routine useful. It takes a contiguous range, starting in A1, and creates a GIF file with a snapshot of the ...
Posted in Excel | 3 Comments »
Wednesday, November 12th, 2008 21 views
In my previous post Shipment Tracking Add-In for Excel I introduced an add-in UDF for tracking package shipments from UPS, DHL and FedEx. A few more caveats about that function:
It appears to only work for domestic (U.S.) shipments.
It does work for FedEx tracking numbers, but only the 12-digit version. There ...
Posted in AddIns, Excel | 2 Comments »
Friday, November 7th, 2008 158 views
Have you ever wanted to incorporate shipment tracking into your spreadsheet application?
I've just completed another add-in for Excel -- this one is a UDF that lets you track shipments you've sent via DHL, UPS or FedEx.
To install:
First, download and save the add-in somewhere special. Here is the file: Shipment Tracking ...
Posted in Excel, UDF | 8 Comments »
Monday, November 3rd, 2008 68 views
Here's a neat trick I use to make spotting worksheet errors very simple.
Wrap your formula in an IF statement that returns the letter "J" if True, or the letter "L" if False, and change the cell's font to Wingdings.
In the Wingdings font, "J" is a smiley face :) and "L" ...
Posted in Excel, Formulas | No Comments »
Add-Ins
Blogs I Read
About the Author
Contact
Loading ...