LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default VBA and Case Insensitive

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)

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 05:57 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"