Posted on 09/09/2022 7:51:19 AM PDT by nikos1121
ZK KFJBY GAOXFHB KA HXAT ON FSI EBGAVB TPA RAO XBFDDR FXB. —B.B. GOVVZSHY
The way it works is a letter stands for another letter. For example: AXYDLBAAXR is LONGFELLOW (does not apply to today's cryptogram).
Beware, the game is very addictive. If this is your first time, don't be intimidated, you’ll be solving them all within a few days. If you’re stumped, take a break and return to it.
PLEASE DO NOT post the answer in general comments, but DO post your time and how you made out.
You can certainly send your solution to my private reply, or if you need a hint for today’s Cryptogram ASK THE GROUP FOR HELP!
I suggest printing these out and work them on paper. If you need a little help you can copy and paste it to Hal’s Helper below.
You can then work on the puzzle without using pen and paper, but I recommend that you do NOT look at the letter counter.
One last request. Feel free to post a fun or clever clue, the more tangential to the quotation the better, but please don’t put the actual words of the quote in the clue.
From The Arkansas Gazette
4 minutes good
3 minutes excellent
2 minutes exceptional
90 seconds superior
Author, 30 seconds.
Yep. Probably should have been lowercase.
shouldn’t the clue be all in lowercase?
reeeeeeeeeeee!!
Well, GAOXFHB and a whole lot of veggies and of course Faith in God.
Quite a few politicians that this quote could be directed at...and rightfully so.
Yep. That’s where I focused.
1. Open Excel
2. Name one of the sheets: Cryptogram
3. Click View > Macros > View Macros
4. Type 'Crypto' into the Macro Name field and click 'Create'
5. Copy the text below over the 'Sub Crypto... End Sub' text
6. Save the Excel workbook as Cryptogram.xlsm (not .xlsx)
7. Enter the cryptogram in cell A1
8. Run the 'Crypto' macro (View > Macros > View Macros > Run)
9. The cryptogram will be separated into individual characters starting in cell D3
10. The alphabet will be displayed from cells A3 to A28
11. Enter a character in Column B and that letter will appear beneath the cryptogram in every cell with the corresponding letter in Column A.
Here's the text to copy:
Sub Crypto()
Dim ws As Worksheet
Dim c As String, lc As Long, i As Long, e As String
Set ws = ThisWorkbook.Worksheets("Cryptogram")
c = ws.Range("A1")
lc = Len(c)
ws.Rows("2:100").Delete
For i = 1 To 26
ws.Cells(i + 2, 1) = Chr(i + 64)
Next i
For i = 1 To lc
ws.Cells(3, i + 3) = Mid(c, i, 1)
Next i
e = Split(ws.Cells(1, lc + 3).Address, "$")(1)
ws.Cells(4, 4).Formula = "=IF(ISNA(VLOOKUP(D3,$A$3:$B$28,2, FALSE))" & _
","""",IF(VLOOKUP(D3,$A$3:$B$28,2, FALSE)=0,""""," & _
"VLOOKUP(D3,$A$3:$B$28,2, FALSE)))"
ws.Range(ws.Cells(4, 4), ws.Cells(4, lc + 3)).Formula = _
ws.Cells(4, 4).Formula
ws.Columns("D:" & e).EntireColumn.AutoFit
End Sub
where do I find yesterday’s answer?
easy, peazy.
The author’s name was a dead give away.
same
CB NLQRL YN URR WCLQU, CY CU BRMRUUDLV YN WRMNXR D ODLY NS YIR UCHRBMR. —LNWRLY HVBQ
Solution to previous puzzle (select the yellow text with your cursor to read):
IN ORDER TO SEE BIRDS, IT IS NECESSARY TO BECOME A PART OF THE SILENCE. —ROBERT LYND
HAL'S CRYPTOGRAM HELPER
Disclaimer: Opinions posted on Free Republic are those of the individual posters and do not necessarily represent the opinion of Free Republic or its management. All materials posted herein are protected by copyright law and the exemption for fair use of copyrighted works.