Monday, 09 April, 2007

1. By Yaanu. Comment posted 09-Apr-2007 @05:21pm:

   I'll trade you an original '59 Gibson Moderne for one of your books.
2. By Tim. Comment posted 09-Apr-2007 @05:24pm:

   I'll trade you a Jesus DVD for your book thanks John. 90 minute video and 4.5 hours of additional footage and special bits.
3. By . Comment posted 09-Apr-2007 @05:26pm:

   You've got a 90-minute Jesus Alou DVD? Sorry Tim, I'm not much into baseball these days.
4. By Vader. Comment posted 09-Apr-2007 @05:40pm:

   How about a 1 year subscription to Rush 24/7 at rushlimbaugh.com?
5. By . Comment posted 09-Apr-2007 @05:51pm:

   My heart felt thanks and I will pay the postage
6. By . Comment posted 09-Apr-2007 @05:55pm:

   How about and Earl Scruggs Family & Friends DVD and a Darryl Purpose & Julie Beaver DVD for a trade?
7. By Dee Why. Comment posted 09-Apr-2007 @06:10pm:

   Trout Mask Replica
8. By Sparkit. Comment posted 09-Apr-2007 @06:23pm:

   I'll send you my Excel 5.1/Mac floppys if you'll give the book to your local library.
9. By . Comment posted 09-Apr-2007 @06:27pm:

   2 LP records: The Waterways of Missouri, Part I and Part II and the Classics Illustrated, Jr. version of The Critique of Pure Reason.
10. By . Comment posted 09-Apr-2007 @06:41pm:

    RickHap - Offer accepted! I'll be in touch to work out the details.
    
    Dee Why - Offer pending additional data. What media format?
    
    Sparkit - Offer rejected. I've been thinking of donating a bunch to the library anyway.
    
    concertinist - Offer rejected. "Waterways of Missouri" sounds fascinating, but I have no way to play LPs. And I have far too many Kant comics as it is.
11. By Dee Why. Comment posted 09-Apr-2007 @07:10pm:

    It's a CD. I'm in Australia but have can email you an LA address for the book if you're happy to do the swap.
12. By Curtis. Comment posted 09-Apr-2007 @07:38pm:

    Two burned CD's - one of rare, vintage Japanese Space Kitty music, another of Running, Jumping, Standing Still a classic 1969 rekkid by John Koerner & Willie Murphy.
13. By . Comment posted 09-Apr-2007 @07:49pm:

    I have a NEW pair of Bose ear-buds and I never get to use them - you can have them in trade for your book; That's 99.00 value!!!. OR I'll send you a flash drive with ALL the Mr. Excel video podcasts up to this date in one convenient location around 4 GIG's in all, so you can get caught up!
14. By Curtis. Comment posted 09-Apr-2007 @07:49pm:

    And I'll throw in a couple others from Arve Henriksen and Son by Juana Molina (if you don't have it).
15. By Curtis. Comment posted 09-Apr-2007 @07:51pm:

    Crap! David really upped the ante.
16. By . Comment posted 09-Apr-2007 @08:10pm:

    Dee Why - Offer Rejected. I'm hoping there will be better offers than a single CD.
    
    Curtis - Offer pending. Juana Molina was almost the deciding factor (I have Segundo, but not Son). I think you're good for more than that.
    
    David - Offer accepted! (Ear buds. You can keep the Mr. Excel videos). Pamn uses ear buds. I will be in touch.
    
    So far, two books have been marked for trade. Let's do four more. I want to hold on to four of them for emergency transactions.
17. By . Comment posted 09-Apr-2007 @08:19pm:

    I recently had a paper shredder explode in my face and cause 1st degree burns on my hands and arms. You can have the shredder. I don't know if it still works, I'm afraid to go near it.
18. By Curtis. Comment posted 09-Apr-2007 @08:24pm:

    Okay, okay... I'll throw in Tres Cosas by Juana Molina; Mercy Now by Mary Gauthier and a Happy Rhodes album, The Keep.
19. By . Comment posted 09-Apr-2007 @08:28pm:

    I will give you a teenage boy who will play on all your computers and instruments, eat all your food, spend all your money, AND I will pay for the postage for you to send me the book, and I will even return the book after I have read it....
20. By . Comment posted 09-Apr-2007 @08:30pm:

    You're getting pretty close to a deal, Curtis. But something tells me that you're good for at least one DVD in that package. And maybe even a package of medium gauge banjo strings.
21. By . Comment posted 09-Apr-2007 @08:41pm:

    I offer you my friendship : )
    
    -MacroMan
22. By . Comment posted 09-Apr-2007 @08:45pm:

    Wendy!, tempting offer. I've been wanting a butler / doorman / gentleman's gentleman, and I think your kid is probably trainable for the position. But, alas, I think trading a live human might present some legal problems. I'll talk to may attorney and get back to you.
23. By Blayne. Comment posted 09-Apr-2007 @08:59pm:

    8' Boa skin.
24. By Michael. Comment posted 09-Apr-2007 @09:08pm:

    I'll tell you there's a small problem with your UniqueItems algorithm on one of your tips pages: http://j-walk.com/ss/excel/tips/tip15.htm
    
    The last part of it should be:
    ****************
    AddItem:
    ' If not in list, add the item to unique list
    If Not FoundMatch Then
    NumUnique = NumUnique + 1
    ReDim Preserve Unique(1 to NumUnique)
    Unique(NumUnique) = Element
    End If
    
    Next Element
    
    ' Assign a value to the function
    If Count Then UniqueItems = NumUnique Else UniqueItems = Unique
    End Function
    ****************
    
    Notice the (1 to NumUnique) instead of just (NumUnique): keeps the 0 position of the array from being pointlessly empty, which usually becomes a problem when you use LBound.
    
    ....oops, guess I don't have too much bargaining power now. :o)
25. By Ivan Peeler. Comment posted 09-Apr-2007 @09:36pm:

    Signor J-Walk,
    
    With due respect, there's a flash ......
    
    Are you pursuing an (Excel) array formula to sort a columnar range in alphabetical order (including blank cells and duplicates) ?
    
    Regards.
26. By major_danny. Comment posted 09-Apr-2007 @11:54pm:

    I'll trade you a D-Link DI-704P router w/printer server. It's a four-port wired router w/ one parallel printer port, barely used.
27. By Patrick O'Beirne. Comment posted 10-Apr-2007 @02:00am:

    I'll swop an autographed copy of my book, 'Spreadsheet Check and Control'
    You may be able to suggest a contribution I can mention in the next edition :-)
28. By Hui.... Comment posted 10-Apr-2007 @02:00am:

    What about my "Now obsolete" copy of "Excel 2003 Power Programming with VBA" ?
29. By Doug Jenkins. Comment posted 10-Apr-2007 @02:14am:

    I am willing to offer this fine air guitar in exchange for the book:
    
    
    
    
    (Case not included)
30. By ross mclean. Comment posted 10-Apr-2007 @04:03am:

    Michael,
    it's 1 based.
    Anyway i think it would be quicker to use a collection?
    
    Function UC(InputRange As Range) As Long
    Dim cl As Range, UniqueValues As New Collection
    Application.Volatile
    On Error Resume Next
    For Each cl In InputRange
    UniqueValues.Add cl.Value, CStr(cl.Value)
    Next cl
    On Error GoTo 0
    UC = UniqueValues.Count
    End Function
31. By . Comment posted 10-Apr-2007 @04:28am:

    A new version of Excel 97 Developer's Edition. CD included! or maybe it included an 8-track?
32. By Andrew. Comment posted 10-Apr-2007 @05:04am:

    I'll show you some Aussie hospitality when you head over this way (beer) ;-)
33. By William Tell. Comment posted 10-Apr-2007 @05:07am:

    Authentic Swiss cheese and/or Swiss chocolate, sent directly from Switzerland. I will buy the cheese directly from the farmer, and the chocolate in the local supermarket (don't know any chocolate farmers)
34. By . Comment posted 10-Apr-2007 @05:25am:

    How about 3 CDs of some British folk/guitarist type people:
    
    John Martyn - Solid Air & The Church With One Bell
    Nick Harper - Live (Son of Roy Harper)
35. By Phillip. Comment posted 10-Apr-2007 @06:25am:

    I have some extra Tom Waits CDs lying around.
    
    But I'm in Canada, so I guess that voids the offer, eh?
36. By Jan Karel Pieterse. Comment posted 10-Apr-2007 @06:39am:

    Hi John!
    
    How about a pound of our famous Dutch salted licourice? (Did I remember correctly you detested those? <g>)
37. By south. Comment posted 10-Apr-2007 @06:52am:

    How about a genuine authentic manual computer cd tray opener? It has only been used once and works perfectly. It is shiny and curvey and kind of resembles a paper clip if it were opened up. Let me know, this offer won't last long.
38. By Woody. Comment posted 10-Apr-2007 @07:16am:

    a Richard Simmons tape.
39. By Tom McMahon. Comment posted 10-Apr-2007 @07:36am:

    Mr. Spreadsheet????. I wonder if Wikipedia has a list of men nicknamed Mister ________ , like they have a list of people known as the Father of or the Mother of something. Gotta find out . . .
    
    In the movie, you could be portrayed by Sidney Portier: They call me Mister Spreadsheet.
40. By . Comment posted 10-Apr-2007 @07:42am:

    Jan Karel, I think I liked that licorice -- in small amounts. In any case, I can pick it up when I visit Amsterdam in July.
41. By Jan Karel Pieterse. Comment posted 10-Apr-2007 @07:50am:

    Hi John,
    
    Darn, I'll be abroad for the most of July I'm afraid.
42. By William Tell. Comment posted 10-Apr-2007 @09:28am:

    If you are in Europe this summer, then I offer free lodging in Zurich, and a guided tour of the Alps (unless you would rather have the cheese/chocolate).
43. By . Comment posted 10-Apr-2007 @09:32am:

    John, I don't want the book since I don't do any programming, but I'll make a batch of muffins if you'll just give me your signature on a white piece of paper. Then I can frame it and hang it over the computer in my home office.
44. By Jim. Comment posted 10-Apr-2007 @10:32am:

    how about this Arizona image? 8"x10" mounted 16"x20"...a $200 value.
45. By Imagineer. Comment posted 10-Apr-2007 @10:45am:

    "They call me Mister Spreadsheet."
    
    Well, now they used to call me Spreadsheet but my real name is Mister Earl
    
    (with apologies to the Cadillacs and Ry Cooder)
46. By Sheldon. Comment posted 10-Apr-2007 @10:48am:

    I'll trade you the book for a email I just got from a Nigerian Prince that could be worth MILLIONS!
47. By . Comment posted 10-Apr-2007 @11:23am:

    How about the past 5 or so years of my life, checking this blog every single day, 5 days a week (I catch up on Mondays for what I missed over the weekend)?
48. By wombat. Comment posted 10-Apr-2007 @12:40pm:

    What the heck is Power programming with VBA?
49. By . Comment posted 10-Apr-2007 @01:26pm:

    Today, is my birthday. I'll trade you a piece of birthday cake + 10 chocolate chip cookies that my 3 year old daughter is baking for me. :)
    
    I'll also throw in a TiVo coffee mug and a Peeps (easter candy) pen!
50. By Tom Berkompas. Comment posted 10-Apr-2007 @01:32pm:

    I'll trade you a license to DataLinks for a copy of the book!
    
    Tom
    COO, Business Intelligence Inc.
    http://www.bidata.net
    The Makers of DataLinks
51. By Jim Cone. Comment posted 10-Apr-2007 @01:34pm:

    A copy of the Excel add-in "Thesaurus for Excel". You no longer will have to struggle to come up with that synonymn for "new".
    An autograph from the developer will be provided separately.
52. By . Comment posted 10-Apr-2007 @02:47pm:

    How about a free photo shoot... in London. I have the gear, all you need to do is drop by.
53. By Rance. Comment posted 10-Apr-2007 @03:27pm:

    Would it be cheaper to just order one from Amazon? I was gonna kick out some carved walrus ivory or 80,000 year old mastadon tusk...or maybe some smoked salmon, but some of these folks are bidding awefully high. I'll never be able to compete with chocolate or beer. Sigh...
54. By John Wilson. Comment posted 10-Apr-2007 @04:16pm:

    I gather from your post that you decided on Amsterdam for a stop-over??
    Good choice.
    How about a personally annotated map of the Red Light District including the "Coffee Houses"?
    Or......
    A pass to get on stage and be part of the show at the Banana Bar (you'll never look at a banana the same way again).
55. By . Comment posted 10-Apr-2007 @05:46pm:

    How about an invitation to visit Wagga Wagga in country Australia as well as a lovely home cooked meal next time you visit Australia?
56. By Nick Hebb. Comment posted 10-Apr-2007 @06:05pm:

    I'll trade you X license(s) of FlowBreeze (a text-to-flowchart add-in for Excel) for the book, where X is any reasonable number.
57. By Nick Hebb. Comment posted 10-Apr-2007 @06:15pm:

    > By Tom Berkompas. Comment posted 10-Apr-2007 @01:32pm:
    > I'll trade you a license to DataLinks for a copy of the book!
    
    If that's the $7500 Pro Suite, then that's a pretty amazing trade for a $33 book.
58. By . Comment posted 10-Apr-2007 @06:42pm:

    I will trade you a slightly used copy of "Databases for Mere Mortals" for a copy of you book. Databases just don't thrill me as much as Excel and VB.
59. By Rance. Comment posted 10-Apr-2007 @06:47pm:

    OK here's one. I'll send you DVD #1 of Animusic. Or do you already have it?
60. By Rance. Comment posted 10-Apr-2007 @08:52pm:

    If you don't send me a copy I will jump! I will!
    
61. By Yo. Comment posted 11-Apr-2007 @05:11am:

    I'm with Wombat... somehow "Power Programming" and VBA just don't mix at all. Very misleading title on that book.
62. By . Comment posted 11-Apr-2007 @07:31am:

    I have personally purchased the 2000 and 2003 editions of this book and convinced several other people to purchase it as well explaining to them that it is my "bible" of all of my programming books. I can't offer much other than my continued support of your book and spreading the word. I will add a link to purchase the book on my website.
    
    I wish I could offer more than that, but other than probably being your biggest fan and convincing several people to purchase your book there isn't much else I have.
63. By . Comment posted 11-Apr-2007 @11:37am:

    I'll try again...how about this Arizona image? 8"x10" mounted 16"x20"
    
64. By Rance. Comment posted 11-Apr-2007 @11:46am:

    Thats it...I'm jumping...
65. By . Comment posted 12-Apr-2007 @07:52am:

    I trade you a slightly warped LP of Firesign Theater's "Don't crush that dwarf, hand me the pliers"
66. By . Comment posted 12-Apr-2007 @11:34am:

    How about a copy of Excel 2002 power Programming with VBA by somebody named Walkenbach?
67. By . Comment posted 12-Apr-2007 @11:58am:

    I will trade you that for a Visit to Argentina and a free allocation to the DOV SIMENS event next May 12 and 13
    
    http://www.hollywood-argentina.com
68. By Zack Barresse. Comment posted 12-Apr-2007 @05:38pm:

    You're shameless John. (vbg)
    
    I was going to say I'd buy you a beer and you can keep your book, but I think Andrew beat me to the punch!
69. By Ivan Peeler. Comment posted 12-Apr-2007 @05:42pm:

    Would you allow me to proofread your future publications ?
    
    Regards.

Original content © 2010, John Walkenbach