+ Reply to Thread
Results 1 to 8 of 8

Go To Special

  1. #1
    Forum Contributor
    Join Date
    01-16-2015
    Location
    Istanbul
    MS-Off Ver
    Office 365
    Posts
    928

    Go To Special

    Can we search numbers which is bigger than 6 with "Go With Special"? I couldn't.

  2. #2
    Registered User
    Join Date
    03-14-2015
    Location
    Hamburg
    MS-Off Ver
    7
    Posts
    32

    Re: Go To Special

    Would be very nice - I couldn't do so neither --> I think that doesn't work this way
    Please click * below in order to Add Reputation

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: Go To Special

    what exactly are you trying to do?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Go To Special

    Quote Originally Posted by FDibbins View Post
    what exactly are you trying to do?
    Here's what it sounds like to me...

    Press function key F5
    Click the Special button. Note the various options.

    They want an option that will take you to cells >6.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  5. #5
    Forum Contributor
    Join Date
    01-16-2015
    Location
    Istanbul
    MS-Off Ver
    Office 365
    Posts
    928

    Re: Go To Special

    I want to find numbers bigger than 6 and smaller than 12 in a range.

    How does "reference" work there in "Go To" for this purpose?

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: Go To Special

    Could you just highlight them with Conditional Formatting?
    Or use filters to filter out all values outside that range?

  7. #7
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: Go To Special

    Could you just highlight them with Conditional Formatting?
    Or use filters to filter out all values outside that range?

  8. #8
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Go To Special

    Quote Originally Posted by zanshin777 View Post

    How does "reference" work there in "Go To" for this purpose?
    Reference would be a cell or range address or a defined named range.

+ 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. [SOLVED] if a cell has a special value, the whole row should get to a special spreadsheet
    By benjamin.grimm in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-08-2013, 09:50 AM
  2. Need to highlight special character and the cells contains special character
    By dhilipan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-26-2013, 01:36 AM
  3. Paste Special Content: with 5 product and paste special content
    By Cuong Pham in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-27-2013, 11:50 PM
  4. VLOOKUP with Special Value
    By Andrew.Trevayne in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-27-2011, 03:28 AM
  5. How to paste special In VBA
    By Jessica.Bush in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-13-2010, 10:42 AM
  6. special average
    By [email protected] in forum Excel General
    Replies: 2
    Last Post: 08-29-2005, 01:05 PM
  7. [SOLVED] Inserting special row
    By Elbowhite in forum Excel General
    Replies: 2
    Last Post: 08-26-2005, 11:05 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