Cell reference in Find method

[jacksmack]

I want to reference a cell on a different sheet using Find. I'm unsure of how to do this.

Thanks.

 

[SkipVought]

Hi,

Reference the sheet

   Set r = Sheets(1).Cells.Find("SomeValue")

Skip,

_{[red]Be advised:[/red] The dyslexic, agnostic, insomniac, lays awake all night wondering...
"Is there really a DOG?"}