Another Drinking Holiday
Sub HappyStPatsDay()
Dim OTheMorning As Shape
Dim TwoYou As Double
OTheMorning.Top = TwoYou
End Sub
Dim OTheMorning As Shape
Dim TwoYou As Double
OTheMorning.Top = TwoYou
End Sub
Update: John wants one that runs without error and I'm happy to oblige.
Sub HappyStPatsDay()
Dim OTheMorning As Shape
Dim TwoYou As Double
On Error Resume Next
OTheMorning.Top = TwoYou
End Sub
Dim OTheMorning As Shape
Dim TwoYou As Double
On Error Resume Next
OTheMorning.Top = TwoYou
End Sub
John Walkenbach:
Obviously, you've been starting early. 'Run-time Error 91'
Please post a version that works!
17 March 2006, 11:24 amDoug Glancy:
Brilliant solution!
17 March 2006, 12:32 pmJohn Walkenbach:
Thanks, Dick. Now it works perfectly.
17 March 2006, 2:29 pmBillkamm:
lol Dick that gave me a laugh to start my day. Thanks.
23 March 2006, 6:56 amBillkamm’s Blog » Blog Archive » St. Patrick’s Day Excel Code:
[...] Source: Daily Dose of Excel [...]
23 March 2006, 6:01 pmTim:
Doesn't do anything here - is it just a joke in code or is it meant to actually work with a shape in a spreadsheet?
23 March 2006, 10:17 pm