Tag-Archive for » Computer Help «

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, March 28th, 2010 | Author:

So on my netbook I have Windows 7, and for some reason the volume function on the taskbar is just wicked slow, so I wanted a quick way to mute, unmute, etc… in a quicker fashion.

Well I found a command line tool that gives you a lot of functions regarding volume, logging off, standby, etc…  So if you grab the program called NirCmd here (http://www.nirsoft.net/utils/nircmd.html) then you can create shortcuts to mute/unmute, raise or lower the volume, etc…

The other option if you have this same issue is to download intellitype and then  you can use some function keys to do the same thing.  I’ve had some issues with this after the computer comes out of hibernation though.  The nircmd stuff seems to always work.

<shrug>  I think what I really want is a mute button on my chrome browser itself.  Pretty much 90% of the time I do not want my browser to make any noise.  I don’t want stupid ads talking to me, or crappy webpage music playing…  I wonder if they’ll add that in for me.

Category: Misc  | Tags:  | Leave a Comment
Wednesday, November 04th, 2009 | Author:

Okay this was one of those things that always annoyed me, but I never really put any effort into fixing.

At work we have *REALLY* long shares on our network so when I would open up explorer or anything I would see:

This_Is_A_Dumb_Share_Name on ‘Server Description goes here (servername)’ (Q:)

Well that means the left pane of my explorer window had to be huge before I could see that the drive letter on that was “Q”    Very annoying.

Well you can change this behaviour very easily with a registry key.  (Only tested in XP)

Create a new REG_DWORD here:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer

Name this new REG_DWORD “ShowDriveLettersFirst”

Value

0= Show drive letters after description (default)

1 = Show drive letters first only on network drives, local drives show after

2 = Don’t display a drive letter (WHAT?!  Why would you do that?!)

4 = Show drive letters before descriptions

So set the value to 4.   Restart and there you go!

Category: Misc  | Tags: ,  | Leave a Comment