+ Reply to Thread
Results 1 to 2 of 2

use numbers with a certain formate and not the rest (text or empty rows) for search loop

  1. #1
    Registered User
    Join Date
    09-12-2012
    Location
    NC, USA
    MS-Off Ver
    Excel 2007
    Posts
    22

    use numbers with a certain formate and not the rest (text or empty rows) for search loop

    Hey there,

    another question for you guys:
    This macro, I got from mike in this forum (thx again) works great but I need to modify it and don't know how exactly. I underlined the code I need to be different. I want the macro to search exactly how it does but to move on without printing any result if the content of the cell it finds with CellPtr is not a number like this:11-3401-9970-1-92.
    So I want it to yump over text or empty rows without doing anything but continuing with the next number.


    Please Login or Register  to view this content.
    Can anyone help me out here???

  2. #2
    Registered User
    Join Date
    09-12-2012
    Location
    NC, USA
    MS-Off Ver
    Excel 2007
    Posts
    22

    Re: use numbers with a certain formate and not the rest (text or empty rows) for search lo

    Is there any chance do do somethign like this:

    Please Login or Register  to view this content.
    Please help!

+ 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