Title case macro gets a "type mismatch" error at the Instr method

		Microsoft Office Forums > Microsoft Word > Word VBA
Title case macro gets a "type mismatch" error at the Instr method

03-05-2020, 09:41 PM

macropod

Windows 7 64bit Title case macro gets a "type mismatch" error at the Instr method

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,525

Use:

Code:

If InStr(1, sUpper_case_ls, sTest, vbTextCompare) = False Then

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Type mismatch error	abenitez77	Excel Programming	7	04-04-2019 08:51 AM
Error in macro "Ambiguous name detected" - but why??	Officer_Bierschnitt	Excel Programming	7	11-30-2015 03:55 AM
Error: "Changes made were lost...reconnect with server", when switching "from" field	randhurrle	Outlook	2	02-25-2015 06:51 PM
remove repeated words with " macro " or " wild cards " in texts with parentheses and commas	jocke321	Word VBA	2	12-10-2014 11:27 AM
VBA in Excel: Add a new Word Document on Template (Type Mismatch Error))	tinfanide	Excel Programming	1	03-29-2012 09:10 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:25 PM.