+ Reply to Thread
Results 1 to 5 of 5

Upper Case excluding specific worksheet

  1. #1
    Forum Contributor
    Join Date
    10-05-2014
    Location
    CALIFORNIA
    MS-Off Ver
    2010
    Posts
    1,812

    Upper Case excluding specific worksheet

    Hi
    I wanted to exclude worksheet 2 and worksheet 4.

    Thanks.

    Please Login or Register  to view this content.

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,834

    Re: Upper Case excluding specific worksheet

    Perhaps
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    10-05-2014
    Location
    CALIFORNIA
    MS-Off Ver
    2010
    Posts
    1,812

    Re: Upper Case excluding specific worksheet

    Thank you :o)

  4. #4
    Forum Contributor
    Join Date
    10-05-2014
    Location
    CALIFORNIA
    MS-Off Ver
    2010
    Posts
    1,812

    Re: Upper Case excluding specific worksheet

    Hi Jindon,
    One more thing please.
    Instead of a if just a specific cell in Sheet2 (B10, E11) and Sheet4 (C9:C20, D10) ?

    from this code:
    If (Sh.Name = "Sheet2") + (Sh.Name = "Sheet4") Then Exit Sub


    Thanks.

  5. #5
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,834

    Re: Upper Case excluding specific worksheet

    Do you mean?
    Please Login or Register  to view this content.

+ 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] Auto upper case does not include specific cell
    By RJ1969 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-17-2019, 09:43 PM
  2. Replies: 2
    Last Post: 12-25-2018, 09:07 AM
  3. [SOLVED] Pasting text into a cell that has Upper Case code for the worksheet
    By rlh in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-05-2014, 12:17 PM
  4. Write a subroutine in a module to change case upon exit of a cell to upper case
    By Stephd22 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-15-2013, 06:39 PM
  5. [SOLVED] Auto upper case for specific range of cells
    By giligancow in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-25-2013, 12:21 PM
  6. [SOLVED] Changing file in all upper case to upper and lower case
    By Sagit in forum Excel General
    Replies: 14
    Last Post: 08-25-2005, 10:05 PM
  7. Replies: 1
    Last Post: 03-09-2005, 05:06 PM

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