Results 1 to 28 of 28

Checking for a specific number in several ranges, popup if it exists (Most efficient way?)

Threaded View

Hyflex Checking for a specific... 07-18-2015, 08:25 PM
alansidman Re: Checking for a specific... 07-18-2015, 08:33 PM
Hyflex Re: Checking for a specific... 07-18-2015, 08:47 PM
SPARKY347 Re: Checking for a specific... 07-19-2015, 09:37 AM
SPARKY347 https://msdn.microsoft.com/en-... 07-19-2015, 09:39 AM
LJMetzger Re: Checking for a specific... 07-19-2015, 11:42 AM
Hyflex Re: Checking for a specific... 07-19-2015, 07:15 PM
Marc L Re: Checking for a specific... 07-19-2015, 07:28 PM
xladept Re: Checking for a specific... 07-19-2015, 07:52 PM
SPARKY347 Re: Checking for a specific... 07-19-2015, 11:04 PM
xladept Re: Checking for a specific... 07-19-2015, 11:21 PM
Hyflex Re: Checking for a specific... 07-20-2015, 11:20 PM
xladept Re: Checking for a specific... 07-21-2015, 03:37 PM
xladept Re: Checking for a specific... 07-21-2015, 01:36 PM
Hyflex Re: Checking for a specific... 07-21-2015, 02:58 PM
Hyflex Re: Checking for a specific... 07-21-2015, 07:12 PM
Marc L Re: Checking for a specific... 07-21-2015, 07:54 PM
Hyflex Re: Checking for a specific... 07-21-2015, 08:31 PM
xladept Re: Checking for a specific... 07-21-2015, 07:52 PM
xladept Re: Checking for a specific... 07-21-2015, 11:05 PM
Hyflex Re: Checking for a specific... 07-22-2015, 07:48 AM
xladept Re: Checking for a specific... 07-22-2015, 05:03 PM
xladept Re: Checking for a specific... 07-22-2015, 04:40 PM
Hyflex Re: Checking for a specific... 07-22-2015, 07:41 PM
xladept Re: Checking for a specific... 07-22-2015, 07:58 PM
Hyflex Re: Checking for a specific... 07-22-2015, 09:19 PM
xladept Re: Checking for a specific... 07-22-2015, 11:09 PM
xladept Re: Checking for a specific... 07-23-2015, 01:20 PM
  1. #1
    Forum Contributor
    Join Date
    09-07-2010
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    358

    Checking for a specific number in several ranges, popup if it exists (Most efficient way?)

    Hi Guys,

    I'm trying to make an efficient number checking macro that looks for the number 250 in certain cells/columns and if it exists to throw a popup.

    Sheet 1:
    Range("D2:J" & LastRow)
    Range("L2:M" & LastRow)
    Sheet 2:
    Range("E15:P" & LastRow)
    LastRow is defined by Column A

    Filters? For loops? Arrays? or Search/Find?

    I'd greatly appreciate some snippets of code to do this in the most efficient way.
    Last edited by Hyflex; 07-18-2015 at 08:47 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Checking if a table already exists
    By JoeSkittles in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-16-2013, 09:11 AM
  2. Checking if a file exists?
    By TomWolowiec in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 07-31-2013, 03:58 PM
  3. Checking to see if a number exists in a column
    By smaier69 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-14-2013, 12:08 PM
  4. [SOLVED] Stop overwrite of file if it already exists, no popup wanted
    By LoneWolf3574 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-06-2012, 07:24 AM
  5. Replies: 3
    Last Post: 01-18-2012, 07:55 AM
  6. [SOLVED] Checking if file name already exists
    By Rob T in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-16-2007, 05:03 AM
  7. [SOLVED] [SOLVED] checking if an url exists
    By Aldo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-09-2005, 06:05 PM
  8. help with checking if dir or file exists
    By greenfalcon in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-08-2005, 03:03 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