The section of my code that is not working is as follows:
With Worksheets("Control Data Sheet (2)").Range("A1")
Range("A1").Value = Me.txtname.Value
Sheets("Control Data Sheet (2)").Name = Range("A1").Value
I get the error "wrong number of arguments or invalid property assignemnt"
This works fine in another spreadsheet so it must be something simple.
Thanks in advance
With Worksheets("Control Data Sheet (2)").Range("A1")
Range("A1").Value = Me.txtname.Value
Sheets("Control Data Sheet (2)").Name = Range("A1").Value
I get the error "wrong number of arguments or invalid property assignemnt"
This works fine in another spreadsheet so it must be something simple.
Thanks in advance