Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
find worksheet by FindMethod
Good Day Group,
Trying to use the FindMethod to lookup if a Worksheet is present. An effort to code as below. Seems I need further advise. Thankkful for any help. Brgds CG Rosén Dim nme As String nme = TextBox1.Text & TextBox2.Text Dim wk As Worksheets Dim k With ActiveWorkbook.Worksheets Set k = .Find(????, LookIn:=????) If Not k Is Nothing Then code..... End If End With |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to find and unlink current worksheet from old worksheet | Excel Discussion (Misc queries) | |||
Find worksheet | Excel Discussion (Misc queries) | |||
Find Max Value in WorkSheet | Excel Worksheet Functions | |||
Range in FindMethod? | Excel Programming | |||
Find top of worksheet | Excel Programming |