Results 1 to 8 of 8

Determining Any Uppercase Letter

Threaded View

  1. #1
    Registered User
    Join Date
    03-31-2009
    Location
    Auburn Alabama
    MS-Off Ver
    Microsoft Office Excel 2007 (Windows)
    Posts
    99

    Thumbs up Determining Any Uppercase Letter

    Hello,

    My question is about determining whether or not a particular letter is uppercase.

    I've written code that reads from a text file one character at a time. And I know that the following determines if each character is equal to the letter "a".

    If Character = "a" Then
    But I want to code an If statement that tells if the character is any uppercase letter. Like "A", "B", "C", etc. I know I could do the following:

    If Character = "A" Or Character = "B" Or Character = "C" Then
    But that seems like a lot of unnecessary typing. Could I possibly use a wildcard character and a VBA type of UCase to accomplish the task?

    If so, how would I code that?

    Thanks for any and all help!
    Last edited by CrazyFileMaker; 04-22-2009 at 09:03 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1