Another month, another verizon v710.

Sure enough my most recent replacement phone started acting up just like the two before it. Each one has gradually become resistant to charging until finally it refuses to charge at all. I get a new phone (using the same old battery) and the charging problems are gone... for a while... until they slowly return... and I won't be able to charge the phone anymore.

The other day I took possesion of v710 number four. This is insane. I love Motorola phones, but I have to say their CDMA phones are shit. I love my Motorola GSM, but I never want to own another CDMA phone again.

Verizon was as helpful as ever... they tried to charge me $75 for the replacement v710 or $150 for a different model. I ended up getting the new 710 at no charge; but seriously, what a bunch of wankers!

Posted by ra in rants, tech at 22:28 | Comments (2) | Trackbacks (0)

If you ever needed a macro to edit the page header of an excel spreadsheet using the currently selected criteria of an autofilter filter within the spreadsheet... then you are pretty lame.
But anyway, here it is:

Sub UpdateHeader()

    ActiveSheet.PageSetup.CenterHeader = "&B&11" &

   Mid(Range("J1").Parent.AutoFilter.Filters(1).Criteria1, 2)

    ActiveSheet.PrintPreview

End Sub

Posted by ra in tech at 22:35 | Comments (0) | Trackbacks (0)

If you are a Firefox user you should know what I'm talking about.

Although it always seemed like it should be useful, I've never been a fan of the search bar. I simply don't like the fact that it keeps your last search sitting up there. What if I searched for "anal invader" last night and this morning one of my coworkers or clients sees that?

More practically, I tend to do a lot of pasting text into the google search box, and I hate that you have to manually erase what is the search bar before you can paste your query. (I'm talking quick middle-button paste, not ctrl-v stuff)

No surprise that some up came up with an extension to change this. The Search Button extension gives you the option of having a Search Button (duh) next to the search bar, but also allows you to set the search bar to auto-clear when you submit your query.

Now that I've installed this extension and started using the search bar, I found two awesome keyboard shortcuts related to it:
CTRL-K gives the search bar focus (what CTRL-L is to the address bar)
ALT-ENTER in the search bar opens the results of the query in a new tab.

Rock on! Now I'm loving the search bar!

Posted by ra in tech at 22:59 | Comments (0) | Trackbacks (0)