No Way Know How

finally think I've figured this out, after many attempts. quite simple really. http://stackoverflow.com/questions/3881209/keep-absolute-reference-even-when-inserting-rows-in-excel-2007 formula is =INDIRECT("[reference]") the crucial part is the quotes. presumably they turn the refernce into a literal string which obviously does not change with the workbook structure.

Private Sub Worksheet_Change(ByVal Target As Excel.Range) If Target.Column < 5 Then Exit Sub If Target.Column > 5 Then Exit Sub On Error GoTo ErrHandler Application.EnableEvents = False Target.Formula = UCase(Target.Formula) ErrHandler: Application.EnableEvents = True End Sub adapted from this forum http://www.excelforum.com/excel-formulas-and-functions/347695-automatically-change-text-to-uppercase.html

https://exceljet.net/keyboard-shortcuts/insert-current-date CTRL + ; when recording a macro, this action will be interpreted as insert "11/05/2016" say - rather than "insert current date" you need = Date instead

https://github.com/get-iplayer/get_iplayer/wiki/documentation my usage so far has been: get_iplayer --type=radio [search term] to locate the Programme ID (PID) then: get_iplayer --type=radio --pid:b00sf0d1