View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Matt J Matt J is offline
external usenet poster
 
Posts: 17
Default Error 1004 when selecting a range

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?