Please help, think im missing something simple

[chris9104]

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

 

[VoG]

Try

With Worksheets("Control Data Sheet (2)").Range("A1")
    .Value = Me.txtname.Value
    Sheets("Control Data Sheet (2)").Name = .Value
End With

 

[jeffreybrown]

Could you be missing the . in front of Range?

 

[chris9104]

thanks guys, new it was something so simple, been staring at it for ages