+ Reply to Thread
Results 1 to 3 of 3

macro code to look up 16 sheets in workbook

  1. #1
    Registered User
    Join Date
    04-05-2012
    Location
    uk
    MS-Off Ver
    Excel 07
    Posts
    77

    macro code to look up 16 sheets in workbook

    Im trying to get the macro to look through sheets 1 to 16 and show the message box if conditions are met the code works ok but only looks up the active sheet not the 16 sheets , heres my code
    Please Login or Register  to view this content.

  2. #2
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: macro code to look up 16 sheets in workbook

    Hi, rjm87,

    wouldn´t it be easier to use an Autofilter for each sheet and work on only the displayed rows instead of looping through nearly 6000 rows?

    Please Login or Register  to view this content.
    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  3. #3
    Registered User
    Join Date
    04-05-2012
    Location
    uk
    MS-Off Ver
    Excel 07
    Posts
    77

    Re: macro code to look up 16 sheets in workbook

    Thanks that does the job , I put an extra 0 in meant to be 600.

+ 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. VBA Code to run a macro on 2 sheets in same workbook
    By cne73 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-10-2013, 10:15 PM
  2. Replies: 6
    Last Post: 03-29-2006, 07:50 AM
  3. [SOLVED] How to repeat a code for selected sheets (or a contiguous range of sheets) in a Workbook?
    By Dmitry in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-29-2006, 07:50 AM
  4. Replies: 6
    Last Post: 03-29-2006, 07:50 AM
  5. VBA Code To have a macro repeat on all sheets in a workbook
    By carl in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-03-2005, 03:50 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