GOT IT!

Took your code and set it into a separate public subprocedure ...
Sheets("SOAUDITITEM").Select
Call PubProcedure.pcdrClearSheet
Application.Goto Reference:="R2C1"

I just select the sheets and call the subprocedure.

thanks for your help.

"Matt J" wrote:

No, it is a click event in another sheet

"JE McGimpsey" wrote:

Are you running the code from the same worksheet as Sheet SOAUDITSO?


In article ,
Matt J wrote:

1004 error changed to "Method 'Range' of object_'Worksheet' failed"