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
Obviously, you’ve been starting early. ‘Run-time Error 91’
Please post a version that works!
Brilliant solution!
Thanks, Dick. Now it works perfectly.
lol Dick that gave me a laugh to start my day. Thanks.
[…] Source: Daily Dose of Excel […]
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?