Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find Function
i used the find fuction in vba, but its case sensitive. How do make it not
case sensitive heres a sample of the code i have so far. Set coolName = Worksheets("Promotional").Range("B4") With Worksheets("USERS").Range("a1:a500") Set c = .Find(coolName) If c = coolName Then Worksheets("Promotional").Range("g10").Value = "test" c.Offset(columnOffset:=5) = "testing" End If End With |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trying to find which function to use | Excel Worksheet Functions | |||
Find Function | Excel Worksheet Functions | |||
Help with the FIND function | Excel Worksheet Functions | |||
Find Function via VB | Excel Programming | |||
backwards find function to find character in a string of text | Excel Programming |