Deleting range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Clear a "moving" range offset from Target 31
named range in macro call 3
Arrays and scattered cell values or another way? 16
Copying a row and pasting the same below it with just formulas 3
Copy a range data from 1 sheet to multiple selected sheets 1
Post my named ranges in column A 10
Excel VBA help: Text file formatting 19
Hiding Rows with Blank cells 5

Back
Top