Hi,
I’m having problems extracting part of a worksheet name to compare to
text string.
I’m getting a 438 error Object doesn’t support this property or method
I have looked in help and the Mid function doesn’t seem to be supporte
in VBA, but I’m at a loss for a substitute. I just need to check if th
first three letters of the worksheet name = CWR
Here is an excerpt of my code.
ElseIf ActiveSheet.Name = "CWR LOG" Then
ComboBoxTopics.ListIndex = 2
ElseIf Application.WorksheetFunction.Mid(ActiveSheet.Name , 1, 3)
"CWR" Then 'This is where the error hits.
ComboBoxTopics.ListIndex = 1
--
Case
-----------------------------------------------------------------------
Casey's Profile:
http://www.excelforum.com/member.php...nfo&userid=454
View this thread:
http://www.excelforum.com/showthread.php?threadid=56220