I have a piece of code that searches to find a string which triggers
the start of an event (copy/paste). However, I cannot control whether
the starting string will be in upper & lower case or a combination of
the two. How can I add code that will recognize the string regardless
of the case?
Any help you can give would be great (I'm relatively new to VBA).
Thanks!
Robin
Here's the beginning portion of my code. It's the strStart that is
causing the problem.
wbCRD.Worksheets("Pts, Driver Class, Age by Pts").Activate
Range("B1").Activate
If strChannel = "Agency" Then
strStart = "Driver Class Factors"
intStartRowOffset = 1
strEnd = "END SECTION"
intEndRowOffset = -2
strColumn = "P"
Else
strStart = "Driver Class Factors"
intStartRowOffset = 0
strEnd = ""
intEndRowOffset = -1
strColumn = "P"
End If
strStartingCell = FindAddress(strStart, intStartRowOffset)
Bookmarks