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.