Set code copy and paste special values

Hi.
I need to copy and paste special values ​​and then delete the columns "A: E"

can anyone help me?
Thank you!

Please Login or Register  to view this content.

Please tell us what you are doing because it doesn't completely make sense?

Copy A:J on worksheet RPA >> pastespecial values to worksheet Dados A1

then delete worksheet Dados A:E ?

Hi.
I need to copy all data from the spreadsheet 'RPA' to the worksheet 'Data' and paste special values​​.

then delete the column 'A' to column 'E'

I'm hoping you mean delete A:E of worksheet RPA?

Please Login or Register  to view this content.

it was great!
Thank you very much!

You are very welcome and thanks for the feedback