Thread: VBA error 1004 "Select method of Range class failed"
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Matt J Matt J is offline
external usenet poster
  
Posts: 17
Default VBA error 1004 "Select method of Range class failed"
Sorry for the duplicate I got an error when it was posting

"Matt J" wrote:

I have the following code in a Macro for deleting a range of cells and it works fine but when I use it in a click event for a command button I receive the error.

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

I know it is something simple. I am new to VBA so please excuse my ignorance.
Reply With QuoteReply With Quote