Results 1 to 16 of 16

Cannot jump to Range because it is hidden

Threaded View

  1. #1
    Registered User
    Join Date
    04-20-2016
    Location
    Basel, Switzerland
    MS-Off Ver
    MS Office 2010
    Posts
    9

    Question Cannot jump to Range because it is hidden

    Apologies if this has been answered before, but I searched multiple forums and did not find a response that was adequate and/or solved my current problem.

    I am in the process of trying to code a Macro for converting text to numbers on 2 separate worksheets (see example below)

     Sheets("SDP LW").Select
        Cells.AutoFilter
        Range("A3").Select
        Range(Selection, Selection.End(xlDown)).Select
        With Selection
        Selection.NumberFormat = "General"
        .Value = .Value
        End With
        
        Sheets("SDP YTD").Select
        Cells.AutoFilter
        Range("A3").Select
        Range(Selection, Selection.End(x1Down)).Select 
        With Selection
        Selection.NumberFormat = "General"
        .Value = .Value
        End With
    The first part goes smoothly and for the second part, I get a debug pop up and the "Range(Selection, Selection.End(x1Down)).Select" portion of the code is highlighted. When I right click on the highlighted portion, I get the message "Cannot jump to range because it is hidden".

    Any ideas for updating the code so it runs would be greatly appreciated.
    Last edited by quailkatie; 04-22-2016 at 05:59 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA to jump to range in contained in a SUMIFS formula
    By johnsspillane in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-16-2016, 01:49 PM
  2. [SOLVED] Cannot jump to worksheet because it is hidden - vba headache
    By blzbub in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 10-15-2015, 01:52 AM
  3. Replies: 5
    Last Post: 09-16-2014, 12:17 PM
  4. Replies: 0
    Last Post: 01-15-2014, 05:17 PM
  5. Search within Range & Quick Jump to Column
    By Saighead in forum Excel General
    Replies: 5
    Last Post: 05-18-2013, 10:27 AM
  6. [SOLVED] Hide columns based on cell value - Unable to set hidden range property of Range Class
    By trillium in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-13-2012, 11:13 PM
  7. jump to specific date in cell-range based on last opening of workbook
    By wamp in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-20-2008, 09:06 AM

Tags for this Thread

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