+ Reply to Thread
Results 1 to 2 of 2

Check if condition for lower case sheetname

  1. #1
    Forum Contributor
    Join Date
    02-20-2023
    Location
    thai
    MS-Off Ver
    2016
    Posts
    106

    Check if condition for lower case sheetname

    Now I use if condition for check sheet (Purchase,AP)
    But sometime sheetname lower case or upper case (PURCHASE,purchase)
    I want to check condition if sheetnamem lower case = purchase or AP

    How to edit my code as below?

    Please Login or Register  to view this content.
    Last edited by fairyme; 09-27-2023 at 10:20 PM.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,446

    Re: Check if condition for lower case sheetname

    I didn't think the sheet name was case sensitive, but try:

    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Change name format including adjusting upper case to lower case
    By johnmitch38 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 07-26-2019, 07:53 AM
  2. Replies: 1
    Last Post: 07-14-2016, 05:51 AM
  3. Check if last word in text string is lower case
    By cmb80 in forum Excel General
    Replies: 10
    Last Post: 11-13-2014, 04:32 PM
  4. [SOLVED] Lower Case to Upper Case but No Auto Correction : Solved by Mod (6StringJazzer)
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-27-2014, 10:44 AM
  5. [SOLVED] IF condition, check more than one cell then Select Case
    By blue.chio in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-15-2013, 09:59 AM
  6. [SOLVED] Convert 1st letter of word to Upper Case and rest to lower case
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-23-2013, 11:44 AM
  7. Replies: 2
    Last Post: 12-09-2005, 05:15 AM

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