+ Reply to Thread
Results 1 to 3 of 3

Limited number of columns and rows

Hybrid View

  1. #1
    Registered User
    Join Date
    02-26-2008
    Posts
    2

    Limited number of columns and rows

    I have received a spreadsheet with only a small number of columns (up to "K") and a small number of rows (25) visible. I am unable to select a "cell" outside this area, although some of the visible cells contain references to cells in the invisible area. How do I unlock the "invisible" area? The sheet is not protected and there are no macros listed.

  2. #2
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    3,527
    gwo102,

    There's probably a manual (menu item) way to do this, but the following macro should do the trick:

    Sub Unhide()
    
    Columns("L:IV").EntireColumn.Hidden = False
    Rows("26:65536").EntireRow.Hidden = False
    
    End Sub
    HTH

    Robert

  3. #3
    Registered User
    Join Date
    02-26-2008
    Posts
    2
    Thanks, Robert,

    Problem solved.

    Gavin

+ 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