+ Reply to Thread
Results 1 to 4 of 4

Simplify dozens of IF functions in macro

  1. #1
    Registered User
    Join Date
    06-26-2011
    Location
    St. Pazova, Serbia
    MS-Off Ver
    MS Office 2010
    Posts
    6

    Simplify dozens of IF functions in macro

    Like the title says, not a problem but:

    Please Login or Register  to view this content.
    Last edited by Mladjone; 06-28-2011 at 08:08 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,464

    Re: Simplify dozens of IF functions in macro

    Not sure about simplifying it because I'm not sure what it's trying to do ... what does the data look like? ... but you can shorten it a little:

    Please Login or Register  to view this content.

    Regards
    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


  3. #3
    Registered User
    Join Date
    06-26-2011
    Location
    St. Pazova, Serbia
    MS-Off Ver
    MS Office 2010
    Posts
    6

    Re: Simplify dozens of IF functions in macro

    What I was thinking was:
    If column E (every cell in that column) in worksheet 2 contains ONLY words "adr" or "" (nothing) then cut row from worksheet 1 to worksheet 2.

    OR... IF it's easier for you:
    If column E (every cell in that column) in worksheet 2 doesn't contains word "hrana" then cut row from worksheet 1 to worksheet 2.

    When I said "Simplify dozens of IF functions in macro" I meant make the same result without so many IF function.

    Thank you for trying.
    Last edited by Mladjone; 06-28-2011 at 03:55 PM.

  4. #4
    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,464

    Re: Simplify dozens of IF functions in macro

    OK, shorter and less IFs:

    Please Login or Register  to view this content.

    Regards

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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