Error 1004 when selecting a range

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

Guest

I have the following code in a Macro and it works fine. When I copy it to a click event for command button I get a Run-time error 1004 "Select Method of Range class failed.

Sheets("SOAUDITSO").Select
Rows("2:2").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Delete Shift:=xlUp

What am I doing wrong?
 
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

1004 error when selecting a range 9
"Run-time error '1004' 5
VBA error 1004 "Select method of Range class failed" 6
Problems with a Run-time error of 1004.... 7
File Name changes with dates and Deleting Rows of Zeros 0
VBA Runtime error '1004' 6
Error 1004 - Autofill 3
help with VBA program to import and add formatted files to one file 0

Back
Top