What is the most complex but pointless thing you've done in Excel?

[Alex_Hayden]

What is the most complex and seemingly pointless (but also cool) thing you've ever done in Excel? I'm curious what everyone has done in their Excel endeavors.

 

[Leandroarb]

Hi Alex!
I made a function to my wife. He is doing a PhD in physical education.
I needed a function that listed the information that was not collected from each volunteer.
This the code:

Public Function DADONULO(rng As Range) As String
Dim intLinha As Integer
Dim r As Range
Dim intCount As Integer


For Each r In rng
If r < 1 Then
cont = intCount + 1
intLinha = (r.Row - 1) * -1
DADONULO = DADONULO & r.Offset(intLinha, 0).Value & ", "
End If
Next
End Function

Not a very complicated function but was very helpful.

 

[elmer007]

You may enjoy this thread on MrExcel:
http://www.mrexcel.com/forum/lounge...l-practical-jokes-pranks-mean-tricks-etc.html

 

[Alex_Hayden]

Read through the thread in it's entirety other day actually, thanks for the recommendation though (I surprised myself with how much it entertained me, honestly)

 

[elmer007]

Read through the thread in it's entirety other day actually, thanks for the recommendation though (I surprised myself with how much it entertained me, honestly)

Wow, that's a really long thread to read through. I've never finished it myself, but I have used it a few times to mess with coworkers. My favorite idea I haven't done yet, but I have it ready: when I change job sites I'm going to leave a file or two in my folder on the shared drive with names like "My Very Personal Info" and whatnot, and the file's open event sends an email to me with the username of anyone that opens it. Then I'm going to call them and ask if there's something in particular that they're looking for haha

Also, on the complex but pointless topic, I made a macro that turned the spreadsheet into the green-on-black scrolling look of the Matrix (the movie). It even scrolled the phrase "THE MATRIX" through the window every now and then.

 

[Alex_Hayden]

when I change job sites I'm going to leave a file or two in my folder on the shared drive with names like "My Very Personal Info" and whatnot, and the file's open event sends an email to me with the username of anyone that opens it. Then I'm going to call them and ask if there's something in particular that they're looking for haha

Bahaha, I'm definitely thinking of doing something like this when I leave my current employer. Something funny and lighthearted, intentionally mean stuff is just bleh.