I'm trying to run the below macro from a userform but it is not working. I do not get any debugging issues, it just doesn't copy and paste.
Basically, the user enters a row number in textbox3 and the macro should copy from A to AL of the specified row and paste it into AN of that same row.
If I run this macro on the sheet itself, then it works fine, but in the userform it does nothing.

With Sheets("Data")
Dim rw As Long
rw = TextBox3
Range("A" & rw & ":AL" & rw).Select
Selection.Copy
Range("AN" & rw).Select
ActiveSheet.Paste
Application.CutCopyMode = False
End With
Thanks for any help.
Luke