+ Reply to Thread
Results 1 to 2 of 2

Proof Reading my VBA for Hiding Rows

  1. 06-23-2018, 05:36 AM #1
    wedzmer
    wedzmer is offline
    Forum Contributor wedzmer's Avatar
    Join Date
    06-13-2014
    Location
    Philippines
    MS-Off Ver
    2016
    Posts
    422

    Proof Reading my VBA for Hiding Rows

    Hello guys, I need help with my vba codes, I don't know what I'm doing wrong but I was trying to use this to hide unused rows for my active sheets.
    Also, I was trying to use it on both sheets (Pre and Post) but on the first sheet I placed my vba on (PRE), it doesn't work so I'm hoping you could assist me.. The code I'm using is as follows:

    Please Login or Register  to view this content.
    Sample file is:
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 06-23-2018, 05:45 AM #2
    bakerman2
    bakerman2 is offline
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,907

    Re: Proof Reading my VBA for Hiding Rows

    Works fine for me on your Pre sheet.
    Please Login or Register  to view this content.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Proof between 2 tabs
    By elysse.nicole89 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-19-2015, 08:37 PM
  2. [SOLVED] Mathematical proof
    By Pepe Le Mokko in forum The Water Cooler
    Replies: 7
    Last Post: 08-26-2014, 02:17 PM
  3. How to remove blank rows, then insert blank row conditionally, PLUS error proof
    By GTS115 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-05-2009, 11:39 AM
  4. Proof of Calculation
    By jxw100 in forum Excel General
    Replies: 2
    Last Post: 10-30-2008, 01:56 PM
  5. Hiding a button when hiding rows
    By fergusor in forum Excel General
    Replies: 2
    Last Post: 08-10-2006, 09:31 AM
  6. Hiding a button when hiding rows
    By [email protected] in forum Excel General
    Replies: 4
    Last Post: 08-09-2006, 02:19 PM
  7. [SOLVED] Hiding column/row labels --without hiding entire columns/rows
    By [email protected] in forum Excel General
    Replies: 2
    Last Post: 10-18-2005, 10:05 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1