Deleting range
 

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.

Deleting range
 

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.