Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is there a way to write this so it will search the
whole workbook at less 10 worksheets Sub aaa() ' WhatToFind = ActiveCell.Value Cells.Find(What:=WhatToFind, After:=ActiveCell, LookIn:=xlFormulas, LookAt _ :=xlPart, SearchOrder:=xlByColumns, SearchDirection:=xlNext, MatchCase:= _ False, SearchFormat:=False).Activate End Sub I want to Thank You Esau |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Search Workbook | Excel Discussion (Misc queries) | |||
Search a Workbook | Excel Discussion (Misc queries) | |||
Search Data from one Workbook and copy it into another Workbook | Excel Discussion (Misc queries) | |||
Search within workbook | New Users to Excel | |||
Search workbook | Excel Discussion (Misc queries) |