T Tim Feb 17, 2004 #1 Can I find a cell address in another sheet in a book without acvtivating the other sheet? Thanks
T Tom Ogilvy Feb 17, 2004 #2 Sure - you just need to qualify where you want to look - a simplified example. With worksheets("sheet9") set rng = .cells.find(What:=Target) End With if not rng is nothing then msgbox rng.Address(external:=True) End if
Sure - you just need to qualify where you want to look - a simplified example. With worksheets("sheet9") set rng = .cells.find(What:=Target) End With if not rng is nothing then msgbox rng.Address(external:=True) End if
