I just merely expressed my view that diaspora wasn't a cultural loss.
Some may find my comment controversial or something but thats upto them.
It would appear to you are the one ruining the thread with your stunningly inaccurate and fatuous analysis of my comments.
We have absolutley no idea of how an alien, godlike or not, would think etc. therefore any speculation about what they would or would not want is pointless.
Put the following in the ThisWorkbook object shown in the VBA Editor
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
If Sh.Name = "SheetName" And Target.Column = 3 Then Sh.Range("F" & Target.Row) = Date
End Sub
Right idea but you can't used a named range in the way you are attempting to.
Even though you have assinged a range name to the column that range doesn't return a column letter the way you want.
There are two ways to approach this.
The first is depending upon how comfortable you would be...
This is a bit of a non-story
First it's the daily mail reporting so I expect sensationalism and disregard things like "panic stricken staff" as the daily mail is full of bullshit like this.
Secondly the picutre is of a "similar" gun. In daily mail speak this probably means it's the first...
Cutting and pasting is what I would use.
I only use ado in spreadsheets when I want to use SQL for data manipulation. Maintaining a spreadsheet to use ado also requires a bit of set up as when you add and remove data you need to keep the named ranges upto date.
Is the issue that it won't install or won't work after installation? If it is the latter right click on the desktop icon and select properties and then under the compatibility tab try using one of the compatibility modes.