MrExcel MVP?

Hi VP,

My Cusack - Bacon was:

1. John Cusack One Crazy Summer with Mark Metcalf
2. Mark Metcalf Animal House with Kevin Bacon

That's EXCELLENT!
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
OKay, the real question here is what is the SHORTEST connection between Kevin Bacon and John Cusack?
This is an EXCELforum and requires only Excel-solutions :oops:

Code:
'Option Bacon

Sub connect()
'SHORTEST connection Kevin Bacon / John Cusack

thisName = "Kevin Bacon"
c = "132223331211-1014-578-35-51-182123"

    For l = 1 To 11
    newName = newName & Chr(Asc(Mid(thisName, l, 1)) - Mid(c, pc + 12, Mid(c, l, 1)))
    pc = pc + Mid(c, l, 1) * 1
    Next
    
MsgBox newName, , thisName

End Sub
 
GREAT! I think Erik wins. I especially like the Option Bacon. HA HA!
 
ok - NOW I'm being stalked!!!
 
[quote
Depending on browser and screen size, you may have to click on the "enlarge image" button
[looks like a sunset with outward-pointing arrows on the corners] to see a legible image.
[/quote]

Or for those of use who work on systems that conatin sensitive government material, we instead get to see a great big screen that indicates the firewall won't allow content from sites containing the keywords personal Backup and Storage. (grumble grumble... yet another ticky mark under my name on Big Brother's Big Bad List... )
 
...patience young grasshopper... wizard Katcher should be along soon enough...
 

Talk about doing that the hard way rather than, say, posting the text and saying "I sent this to Barry." ;)

Incidentally, I have a shirt that says that ("I solemnly swear...").

Depending on browser and screen size, you may have to click on the "enlarge image" button
[looks like a sunset with outward-pointing arrows on the corners] to see a legible image.

In Firefox it's just a little magnifying glass. No "sunsets" here :)
 

Forum statistics

Threads
1,221,604
Messages
6,160,747
Members
451,670
Latest member
Peaches000

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top