Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
running a sub when found
hello, I have an interresting problem. i'm writing a sub that must execute another sub when the criteria has been met. E.G. IF worksheetS("test").cells.find("testing") = true then (execute anther subroutine) I can't get anything to work. Regards, Niek ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
running a sub when found
Niek,
If I understand your problem correctly, try something like Dim FoundCell As Range Set FoundCell = Worksheets("Test").Cells.Find("testing") If Not FoundCell Is Nothing Then ' string found DoSomething Else ' string not found End If -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "solo_razor" wrote in message ... hello, I have an interresting problem. i'm writing a sub that must execute another sub when the criteria has been met. E.G. IF worksheetS("test").cells.find("testing") = true then (execute anther subroutine) I can't get anything to work. Regards, Niek ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
No data found | Excel Discussion (Misc queries) | |||
File not found | Excel Discussion (Misc queries) | |||
Macro cannot be found, but it is there? | Excel Discussion (Misc queries) | |||
IF NOT FOUND | Excel Worksheet Functions | |||
Which Path not found? | Excel Programming |