Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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) |