Web    www.BenSwenson.com
Latest News buffer (0)News Archive
[Ben]:Proud Papa Moment Discuss This [9 comments so far] View Comments

Overnight in windy, below-freezing weather without a tent. She stayed toasty warm and slept the night through.
Permanent Link:
Proud Papa Moment
[Ben]:An idea whose time has come: Franks Red Hot Salt Discuss This [0 comments so far] View Comments
Removing the liquid component from Franks Original Red Hot Sauce results in a salty/spicy flavoring that could be used for rubs on meats, as a sprinkle-on seasoning for foods, seasoning for chips and popcorn, or anywhere that salt would be added but an extra kick is desired.

If you want to test this yourself, fill the bottom of a ceramic or glass bowl with 1/8" of Franks Original Red Hot Sauce. Let sit overnight. Scrape the resulting crust from the bottom of the bowl and crush into a powder.

So, until Big Hot Sauce gets their act in gear, you too can try this creation.

I think I'm going to submit this idea to Reckitt Benckiser Inc.
Permanent Link:
An idea whose time has come: Franks Red Hot Salt
[Ben]:Excel Random Selection update Discuss This [0 comments so far] View Comments
Today there was a note waiting for me from an anonymous reader who was having trouble with a macro I made available a few years ago.
Hi there,

I wanted to use your macro on this link:
http://www.benswenson.com/news.php?ctrl=viewNews&objid=1673. But when trying to run the macro I get a Random Select Macro - Compile Error: Sub or Function not defined Error. Could you perhaps point me in the right direction for getting the macro to work under Excel 2010?

Thank you.

I'd reply directly to you, but you didn't leave any contact info, so here's the solution.

To get this macro to work, you need to add the following function:
Public Function GetColumnLetter(colNum As Long) As String
Dim i, x As Long
For i = Int(Log(CDbl(25 * (CDbl(colNum) + 1))) / Log(26)) - 1 To 0 Step -1
x = (26 ^ (i + 1) - 1) / 25 - 1
If colNum > x Then
GetColumnLetter = GetColumnLetter & Chr(((colNum - x - 1) 26 ^ i) Mod 26 + 65)
End If
Next i
End Function

Good luck!
Permanent Link:
Excel Random Selection update
[Ben]:Guns in school zones! Discuss This [0 comments so far] View Comments
The lines between sarcastic humor and reality are so blurry these days that sometimes I have a hard time spotting the jokes.

Permanent Link:
Guns in school zones!
[Ben]:Good night, old girl Discuss This [1 comment so far] View Comments

Don't worry Lucy, I won't get your toys. You will be missed.
Permanent Link:
Good night, old girl
[Ben]:Stuff Adelle Says Discuss This [0 comments so far] View Comments
Today Adelle got my copy of Tunnel in the Sky off the shelf. Cara asked her what the book was called. She said "Heinlein."

Cara texted me at the time and mentioned it at dinner (without using any of the key words) and I said "Wow, she knows the author!". Then, thinking better of it, I demurred "Or at least something she heard in association with the book."

Cara thought about it for a second, shrugged and asked Adelle "Who wrote Tunnel in the Sky?" No visual cues at all.

Adelle didn't miss a beat. "Heinlein."
Permanent Link:
Stuff Adelle Says

BenSwenson.com Home
User ID:
Register here
88 users 8203 posts 0 active users
Contact Administrator
Contact Picture of the Day
Phone Me
Picture Archive
New images
Picture of the day
Schlock Mercenary
The LawDog Files
View From the Porch
Alex Mattingly
Smallest Minority
Amazon Affiliate Link
Individual Sponsors
Thrim LLC

©2015 by Ben Swenson.   All rights reserved.
Reproduction in whole or in part without permission is prohibited.
     Hosted by: