Tag-Archive for » Video «

Friday, November 12th, 2010 | Author:

Okay… This one has always bugged me.  I like to have an ID or identity field on my rows even in spreadsheets just so that when I resort them someone can still say “Look at item #67” and I know what they are talking about.

Well I pieced together some stuff I found on the web (I think this was where I found the example of the max_Each_Column function) and this appears to do the trick. Very useful and I absolutely love it.  It requires a macro enabled excel file, but that is the price we pay…

Here is a YouTube video of it…

Add this code to your worksheet and then modify it as needed  to get the correct columns.  As-is when you type in column b and then leave the cell it will add a value to the cell in column A.  It looks in the column A, finds the max value and then adds one to it.  If the ID already has a value then it leaves it alone, so editing rows doesn’t repopulate your ID field.  Easy peasy right?

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 2 Then 'This is the column that causes the ID to be created
'This uses the target offset so it assumes in two spots below that the column to update is "A" and
'that the column is one position to the left of the target column above
    If Target.Offset(0, -1).Value = "" Then
       Target.Offset(0, -1).Value = Application.WorksheetFunction.Max(Columns("A")) + 1
    End If
End If

End Sub

Function Max_Each_Column(Data_Range As Range) As Integer
    Dim TempArray() As Double, i As Long
        If Data_Range Is Nothing Then Exit Function
        With Data_Range
        ReDim TempArray(1 To .Columns.Count)
        For i = 1 To .Columns.Count
            TempArray(i) = Application.Max(.Columns(i))
        Next
    End With
        Max_Each_Column = TempArray
End Function
Category: Excel  | Tags: , ,  | 13 Comments
Sunday, October 11th, 2009 | Author:

I guess I’ve never really seen much in the way of performance art that actually impressed me or struck me as real art.  I guess everything I’ve seen was just some guy throwing paint at a canvas…where seeing it being made didn’t really add anything…  The only performance art I ever really liked was Bob Ross, but I guess that was really more instructional rather than performance… well anyways…

This is f’ing awesome…

Category: Misc  | Tags: ,  | Leave a Comment
Friday, September 11th, 2009 | Author:

Okay the original song from Feist is very catchy and really sticks in my head… but this version from Sesame Street sticks in my head even more than the original one.

1…2…3…4 chickens just back from the shore…

Category: Music  | Tags: ,  | Leave a Comment
Saturday, April 18th, 2009 | Author:

This is probably one of the more impressive pieces of equipment I’ve ever seen… I love it.

Category: Misc  | Tags: ,  | Leave a Comment
Sunday, March 08th, 2009 | Author:

Okay….the fact that this is at real speed is just ridiculous… I’d love to ride with someone like this in an F3000 car (Is that the same as F1?  I have no idea…)   I’d probably have to wear a diaper, but man it would be sweet.

Category: Cars  | Tags: , ,  | Leave a Comment