+ Reply to Thread
Results 1 to 3 of 3

Determin sheet name and don't do the following steps

  1. #1
    Forum Contributor stojko89's Avatar
    Join Date
    05-18-2009
    Location
    Maribor, Slovenia
    MS-Off Ver
    MS Office 365
    Posts
    913

    Determin sheet name and don't do the following steps

    Hi,

    I'm having problems with this part of the code...what I'm trying to do is check if the active sheet name is"Izdaja" or "Certifikati" if its true then don't do the following steps if it's not true then do the following steps.
    This code works:
    Please Login or Register  to view this content.
    But I don't get it what this doesn't work...what am I doing worng here?
    Please Login or Register  to view this content.
    Could someone please help me out with this

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,493

    Re: Determin sheet name and don't do the following steps

    Possibly your spelling for "Not" is incorrect in line 3?

    I would use "and" instead of "or"

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor stojko89's Avatar
    Join Date
    05-18-2009
    Location
    Maribor, Slovenia
    MS-Off Ver
    MS Office 365
    Posts
    913

    Re: Determin sheet name and don't do the following steps

    Hi davesexcel,

    The "Not" spelling was incorrect here but it was ok in the code haha...was typing the "not" here

    Thank you for your suggestion about using "and" insted of "or".
    This code now works as expected!
    Please Login or Register  to view this content.
    Thank you very much for your help!

    BR, Denis

+ 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] Simplify Calculation, remove steps from existing sheet
    By snuffnchess in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-07-2016, 03:56 PM
  2. option buttons to determin combobox information
    By hobbsie in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 12-12-2014, 04:46 AM
  3. [SOLVED] Determin Hrs per time bracket
    By pk24 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-03-2013, 09:59 PM
  4. [SOLVED] Determin in which named range is the activecell
    By stojko89 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-24-2013, 08:49 AM
  5. how to determin how many hours between two different times
    By Dotty in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-07-2012, 05:14 AM
  6. simplifying macro to repeat steps in every sheet
    By roth_nj in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-28-2009, 10:19 PM
  7. Determin x value from a y
    By bruteforce in forum Excel General
    Replies: 7
    Last Post: 04-27-2009, 12:36 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