Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
help with debug
Why is this not working?
Sub FindSheet() Dim Temp As String Dim i As Integer Temp = InputBox("Enter Sheet Name") For Each Sheet In ActiveWorkbook <<< Bombing here at this line !! If ActiveSheet.Name = Temp Then MsgBox "Found the sheet!", vbOKOnly End If Next End Sub Thanks in Advance, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
DeBug | Excel Discussion (Misc queries) | |||
help with debug | New Users to Excel | |||
No debug box | Excel Programming | |||
debug - | Excel Programming | |||
debug help | Excel Programming |