T
Tanya
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.
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
the research I have seen simply confuses me more.
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