I really really really hate my iPhone a lot right at this moment. Someone gave me their phone number last night. I entered the contact name and hit save, then entered a phone number and hit save, then I must have just hit the Home button, instead of hitting that all important last save (for the whole contact).

Cut to a little while later, when I went to send a text, and the contact is gone. Unsaved. Too bad, so sad.

HATE PHONE!

Well, Sean, I'd be happy to take that problem phone off your hands. I'll even pay for postage.

In unrelated to iPhones stuff:

I would like to program an Excel macro that does this: Scans a column until if finds a blank cell. Moves over two cells (say from Column A to Column C) and copies what's in the new cell. Flips over to sheet 2 and searches for what it just copied. If it finds it, it will select that cell and the three cells next to it, copy those and flip back to Sheet 1. It will then paste what it just copied into cells D and on. Then it will resume searching column A for blanks. If it doesn't find what it's looking for, it will go back and move to the next blank cell and search again.

I'm probably not being clear.

I might - if I were in your shoes - remove AVG altogether, test the connect, then reinstall from a new download.

I'll give that a shot when I get home.

Someone refresh my memory: there's no reason why I couldn't change the whois/domain info for my site to a P.O. box, is there? My hosting company has a privacy service, but anything that gets sent to the physical address is automatically tossed, not sent on to me. On the off chance that someone out there is trying to send Gothic Charm School shiny goodies I would want, I was thinking of using our household P.O. box as my whois info.

OK, I am about to cry. Please keep in mind I do not own a digital camera.

I am trying to get the pictures off a Kodak EASYSHAREC340 onto a ac with the latest OS.

When I last did this, the camera showed up as a little harddrive, and I could drag the pictures over. The camera is set to auto. It is plugged into the computer. nothing is happening!

Is it turned on? Mine won't register unless I power it up. If that's not the issue, as it usually is for me, I'd restart the computer and try again.

I am not sure if the camera is on but I think it is. It is set to auto and there is a blinking green light. There are a million other settings-- a book with a heart on it, SCN, a person swimming, hills, a flower,,,so I don't know if there is a special setting for transferring

I have restarted-- is there some sort of order I am supposed to do things in-- like turn the camera on and then plug in-- or plug in then turn the camera on?

Many (most?) cameras have an option to either appear as a simple external drive (what you want) or... something else, that results in the computer loading special photo synchronizing software. Possibly this setting got changed. Can you go through the camera's settings and find this option? (Dunno what it would be called.)

"Auto" I think refers to the camera taking pictures in Automatic mode.

I have restarted-- is there some sort of order I am supposed to do things in-- like turn the camera on and then plug in-- or plug in then turn the camera on?

No, if it's USB it shouldn't matter.

Here's some info: [link]

Ah, this is the problem: [link]

4. Turn on the camera.

Kodak EasyShare software opens on your computer. The software prompts you through the transfer process.

So (the way the camera is set at the moment) you need the EasyShare software already installed. This "feature" needs to be turned off, so the camera appears as a simple USB drive. Hopefully it has that option, but so far I don't see it. If that's not an option, you'll have to pull the memory card and stick it into a card reader that's connected to your computer.

MM, your problem would be ideally suited to do with database software, such as Microsoft Access. Otherwise, you'd need VBA (Visual Basic for Applications) code to do it in Excel. I wrote some code (to brush up on my VBA for Excel skills) - the problem is there's a million ways to do it, and I'm not at all sure my solution is the simplest and/or best suited for what you're doing. (Actually, it's a bit overly complex at the moment.) But it works.

I'm posting it here for you to play with, but I can make adjustments for you tomorrow (and explain how to use it if need be):

Sub findfill()
    Dim mySheet As Worksheet
    Dim r As Range
    Dim rKey As Range
    Dim i As Integer
    Dim rLkup As Range
    Dim rDest As Variant
    
    Set mySheet = Worksheets("Sheet1")
    'manually set the range to run this program against:
    Set r = mySheet.Range("a2", "a14")
    For i = 1 To r.Cells.Count
        If r(i) = "" Then
            Set rKey = Cells(r(i).Row, r(i).Column + 1)
            r(i).Value = rKey
            Set rLkup = LookupKey(rKey.Value)
            If rLkup Is Nothing Then
                'do nothing - no match found
            Else
                Set rDest = Range(Cells(r(i).Row, r(i).Column + 2), Cells(r(i).Row, r(i).Column + 4))
                rLkup.Copy (rDest)
            End If
        End If
    Next i
    
End Sub


Private Function LookupKey(vIn As Variant) As Range
    Dim r2 As Range
    Dim rRet As Range
    Dim i As Integer
    Dim lkupsht As Worksheet
    
    Set lkupsht = Worksheets("Sheet2")
    'manually set the range for the lookup data to be used:
    Set r2 = lkupsht.Range("a1", "a10")
    For i = 1 To r2.Cells.Count
        If r2(i) = vIn Then
            Set rRet = Worksheets("Sheet2").Range(lkupsht.Cells(r2(i).Row, r2(i).Column), lkupsht.Cells(r2(i).Row, r2(i).Column + 2))
            Set LookupKey = rRet
                               
            Exit For
        End If
    Next i
End Function

You'd have to customize it for the range you're running this against and the range of the data on sheet 2 you're looking up. I put comments (i.e. the lines preceded by a ') before the lines you'd need to adjust. Also not that it expects the two sheets to be called "Sheet1" and "Sheet2".

'findfill()' is the subroutine that you'd actually run.

Surprise, surprise. The culprit in my Internet fiasco was, in fact, motherfucking Norton. I don't know why it suddenly started doing it now, but it has apparently decided it really does not play well with AVG or something. After I disabled it and let the AVG update finish downloading, things worked again. After I enabled it again, the problem came back. So I finally went in and told it to shut up and never come back on again unless I say so. I think the only additional benefit Norton provided me was a Firewall, and Windows XP comes with a firewall. Should I enable it? I don't think AVG Free 8.0 has a Firewall, just a "Resident Shield," which doesn't seem to be the same thing.