Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is there any better way (less code) to check if a sheet is a worksheet?
Function CheckIsWorksheet(strSheet As String) As Boolean Dim sh As Object For Each sh In ActiveWorkbook.Worksheets If sh.Name = strSheet Then CheckIsWorksheet = True Exit Function End If Next sh CheckIsWorksheet = False End Function RBS |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel worksheet - Can I make changes in one sheet affect contents of other sheet? | Excel Discussion (Misc queries) | |||
summary data sheet from worksheet to worksheet | Excel Worksheet Functions | |||
Can I copy Everything in a worksheet to a new sheet EXCEPT the te | Excel Worksheet Functions | |||
copy cell from one sheet of worksheet to another sheet | Excel Discussion (Misc queries) | |||
Worksheet - Functions from sheet to sheet | Excel Discussion (Misc queries) |