What do you use your Scotch Tape for?

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
--snip--
"Remember, if the women don't find you handsome, they should at least find you handy." - Red Green

Everyone bow your heads and follow along:

"I'm a man,
but I can change,
If I have to,
...I guess."

:rofl:

Dan
 
Code:
Everyone bow your heads and follow along:
 
"I'm a man,
but I can change,
If I have to,
...I guess."
 
:rofl: 
Dan

Ahhh, Dan... It has been 20+ years since I lived in Mountain View, CA....Things have changed far too much for me to ever return, I fear...:laugh:
 
‘SCOTCH TAPE –vs- POST IT NOTE nested “If” macro, that has been running continually for me for years.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>
<o:p></o:p>
Code:
Sub PostItNoteVsScotchTape ()
<o:p></o:p>
If (you need to use a [FONT=Times New Roman]POST IT NOTE [/FONT]) Then<o:p></o:p>
    If (environment is clean + no wind) Then<o:p></o:p>
        Use POST IT NOTE only<o:p></o:p>
    ElseIf (environment is clean + windy) Then<o:p></o:p>
        Use POST IT NOTE + SCOTCH TAPE<o:p></o:p>
    ElseIf(environment is dirty + windy) Then<o:p></o:p>
        Use POST IT NOTE + SCOTCH TAPE + MORE SCOTCH TAPE<o:p></o:p>
    ElseIf(environment is dirty + windy + BEANIE THE CAT is loose)
        Do While BEANIE THE CAT is still loose<o:p></o:p>
            Chase BEANIE THE CAT<o:p></o:p>
        Loop<o:p></o:p>
        Lock up BEANIE THE CAT in his room again<o:p></o:p>
        Use POST IT NOTE + SCOTCH TAPE + MORE SCOTCH TAPE<o:p></o:p>
    Else<o:p></o:p>
        ‘Do nothing because nothing else matters<o:p></o:p>
    End If<o:p></o:p>
End If
<o:p></o:p>
End Sub
 

Forum statistics

Threads
1,222,628
Messages
6,167,175
Members
452,101
Latest member
xuebohan

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