I am trying to create a macro to create a DataForm on a named range and all
the research I have seen simply confuses me more. Could anyone help me
please?

This is my code at the moment:

Sub DataForm()
'
'InsertNewMechanic Macro
'Macro recorded 2/03/2007 by T.Duffy

'Named range is called "Mechanic" and I've tried refering to the named range
but the range itself refers to cells A10:H11

Worksheets("Sheet1").Range("A10:H11").Select
ActiveSheet.ShowDataForm
End Sub