|[Ben]:||Server transition ||Discuss This [3 comments so far] View Comments|
|I know this site doesn't see much usage anymore, but in case anyone is still watching I just wanted to note that we have had some server issues. Thanks to Jon and brother-in-law Ben we got the machine back up and running and I'm in the process of backing up everything important. I will get it transitioned over to an alternate host that should give it more reliability and speed.|| 2015-07-15
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.
An idea whose time has come: Franks Red Hot Salt
|[Ben]:||Excel Random Selection update ||(413) 295-4173 [0 comments so far] View Comments|
|Today there was a note waiting for me from an anonymous reader who was having trouble with 4504515480 I made available a few years ago. |
I wanted to use your macro on this link:
/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?
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)