Results 1 to 4 of 4

Exclude reading some sheets

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-16-2012
    Location
    Latina, ITALY
    MS-Off Ver
    Excel 2010--2016
    Posts
    947

    Exclude reading some sheets

    Good morning I would need to change a code that allows me to exclude some from reading sheets.
    .....
    For Each ws In Sheets
    ******** If ws.Name <> "Sheet1" And ws.Name <> "96915 40X160" And ws.Name <> "96915 60x160" And ws.Name <> "96915 80x160" Then
    ......
    I wish I had something like:

    ** If ws.Name <> "Sheet1" And ws.Name <> Left ("96915.5" Then
    but I can not write it

    thank you so much.
    Last edited by Richard Buttrey; 12-16-2016 at 07:54 AM. Reason: missing code tags

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Exclude 2 sheets and Run the Macro
    By Sri.n in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-15-2014, 10:03 AM
  2. Need to run this macro on all sheets except those I'd like to exclude
    By Adam1027 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-27-2014, 06:03 PM
  3. Help in VBA - Reading Data between different sheets
    By gandhiaarti in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-15-2014, 04:01 AM
  4. Need to change code that loops all sheets TO exclude some sheets.
    By sherrie777 in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 04-10-2010, 05:29 PM
  5. Exclude some sheets
    By maxwell13 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-03-2007, 01:10 AM
  6. Reading Forms in Sheets...
    By Budfroggy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-06-2006, 08:10 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