I been having some trouble to delete an are in another worksheet, look simple
but I keep having an error, I did this:

Private Sub CommandButton2_Click()

Worksheets("Download").Range("A2:d200").Clear

End Sub
I also want to move the columns 1,2 and 3 to "Donwloads" starting in the row
2 that is previouslly clear to the columns 1, 4 and 5.

thanks a lot.

Hi Orlando,

Don't know the answer to your first problem. However, make sure that all
your spelling is correct. You have "Download" and "Donwloads" in your post.

The second problem: Could it be that you are trying to copy an entire column
and paste it in from row 2 because if so, it will not fit. You have one more
row than the number that will fit from row 2 to the bottom of the worksheet.

Regards,

OssieMac


"Orlando" wrote:

I been having some trouble to delete an are in another worksheet, look simple
but I keep having an error, I did this:

Private Sub CommandButton2_Click()

Worksheets("Download").Range("A2:d200").Clear

End Sub
I also want to move the columns 1,2 and 3 to "Donwloads" starting in the row
2 that is previouslly clear to the columns 1, 4 and 5.

thanks a lot.