Posted to microsoft.public.excel.programming

ExcelMonkey ExcelMonkey is offline

external usenet poster

Posts: 553

Ignore Case without using Regular Expressions

Can I compare two text strings and ignore case without using Regular
Expressions? Is there a regular VBA text function I can use?

If IgnoreCase(Array1(0)) = IgnoreCase(Array2(0)) then
'Do something

End if

Thanks

EM

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Get rid of with regular expressions	Howdy	Excel Discussion (Misc queries)	1	January 18th 10 07:42 PM
Regular expressions	Dave	Excel Programming	5	September 20th 07 02:46 PM
Using Regular Expressions with VBA	Andrew Hall NZ	Excel Programming	5	November 21st 06 09:30 PM
Regular expressions	JeffMelton	Excel Programming	2	March 1st 06 12:52 AM
Regular Expressions in VBA?	Rob[_23_]	Excel Programming	13	February 10th 05 05:34 AM

All times are GMT +1. The time now is 08:11 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us