Results 1 to 12 of 12

Thread: VBA Hiding Unused Cells

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. 08-06-2009, 07:59 AM #1
    mdmackillop
    mdmackillop is offline
    Administrator
    VP-Knowledge Base     VBAX Grand Master mdmackillop's Avatar
    Joined
    May 2004
    Location
    Scotland
    Posts
    14,489
    Location
     
    Sheets("Warehouse Personnel Form").Select 
On Error Resume Next
Range("B63:B65").SpecialCells(xlCellTypeBlanks).EntireRow.Hidden = True 
On Error GoTo 0
    Last edited by Aussiebear; 03-30-2023 at 02:32 PM. Reason: Adjusted the code tags
    MVP (Excel 2008-2010)

    Post a workbook with sample data and layout if you want a quicker solution.

    To help indent your macros try Smart Indent

    Please remember to mark threads 'Solved'
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules