View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Luc[_3_] Luc[_3_] is offline
external usenet poster
 
Posts: 24
Default find a value in another sheet

following coding works find, however.....

Worksheets("a").select

Cells.Find(What:=zoek, After:=ActiveCell).Activate
rownr = ActiveCell.Row
colnr = ActiveCell.Column

if I don't use Worksheets("a").select and am located in a different sheet
e.g. worksheets("b").... it doesn't work. Is there a way to point to a
specific sheet from within the find command no matter in which worksheet you
are located at that time.