Problem: I had an Excel spreadsheet with email addresses. I wanted to add the mailto: hyperlink to a range of cells. The answer came from Suat at experts-exchange.

Goto Excel VBA (Alt+F11) and Insert->Module to add a new module then copy And paste the following code into this new module. Then return excel and select the range which has email addresses (you can select other cells, you don't have to use multiply selection) and then run the macro by pointing Tools->Macros->Macros and selecting ChangeToEmail macro. Code will look into selected range and change the cell to a hyperlink if cell has an email address in it by using cell value as email address.

'—-Code Start—
Sub ChangeToEmail()
Dim rng As Range
Dim cll As Range
Dim tmpval
   Set rng = Selection
   For Each cll In rng.Cells
       tmpval = cll.Value
       If InStr(cll, “@”) > 0 Then cll.Hyperlinks.Add cll, “mailto:” & cll.Value
       cll.Value = tmpval
   Next cll
End Sub
'—-Code End—

Feed Validator has moved. The Feed Validator, previously located at feeds.archive.org/validator/, now has its own domain: http://feedvalidator.org. If you have any scripts, templates, or applications that point to the Feed Validator, now would be a good time to update them. (204 words) [dive into mark]

Hey, thanks for telling everyone…finally. I ended up using the Redland RSS 1.0 Validator yesterday when my favorite validator was not found. I thought they probably took the server down for maintenance. Today I find out its moved. I checked both feeds and my 1.0 feed failed because the channel description used dublin core. I took the dc: out and the feed validated. I then updated the footer in my dreamweaver templates for the new url to the validator.