View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jan Kronsell[_3_] Jan Kronsell[_3_] is offline
external usenet poster
 
Posts: 34
Default Problems, doing a find in another sheet.

Additionally:

If I change my code to only contain

Sheets("data").Range("a1").Activate

I get the same error, so it seems my problem is how to activate a cell in
one sheet, from code on a button in another.

Jan