Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do i use find in VB
Dear sir,
I am trying to use VB to find data, not in the same worksheet but in whole workbook. I programed in VB as the following: Sub Button1_Click() Cells.Find(What:="", After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _ xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _ , SearchFormat:=False).Activate End Sub Well, it works to find data at the active worksheet but I need to find data at different worksheets(all workbook) I tried to use Xlsearchwithin.Xlwithinworkbook but it keeps giveing an error. Please could you help me. Yours Taufik |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find First Non blank cell than find column header and return that value | Excel Worksheet Functions | |||
Despite data existing in Excel 2002 spreadsheet Find doesn't find | Excel Discussion (Misc queries) | |||
find and delete duplicate entries in two columns or find and prin. | Excel Programming | |||
find and delete text, find a 10-digit number and put it in a textbox | Excel Programming | |||
backwards find function to find character in a string of text | Excel Programming |