Hello everyone !
I need some help please.
I canīt copy information from a textbox (userform) to a range in a worksheet because an error appears when the code try to past the information in range
The error is this : "run time error 1004 paste method of worksheet class failed"
The code of my vba macro is :
if textbox.value = "TABELA" then
textbox.Copy
Sheets("TARIFAS").Select
Cells(1, 1).Select
ActiveSheet.Paste --> The error appears here
Sheets("TARIFAS").Visible = False
Else
End If
CAN SOMEONE HELP ME please ?
Regards
Bookmarks