Post Reply  Post Thread 


Can I create a macro in Microsoft Excel that will
Author Message
kjschuit
Junior Member
**


Posts: 1
Group: Registered
Joined: May 2007
Status: Offline
Reputation: 0
Post: #1
Can I create a macro in Microsoft Excel that will

hide a row if a particular condition is met? If so, how?

05-23-2007 04:55 AM
Find all posts by this user Quote this message in a reply
tobanator
Junior Member
**


Posts: 1
Group: Registered
Joined: May 2007
Status: Offline
Reputation: 0
Post: #2
 

Declare the var, point it at a cell, check to see if the value of the cell is 1, if it is, hide the row, if it isn't unhide it (EntireColumn is another option)Sub hideColumns() Dim Rng As Range Set Rng = Range("B1") If (Rng = 1) Then Rng.EntireRow.Hidden = True Else Rng.EntireRow.Hidden = False End If End Sub

05-23-2007 06:37 AM
Find all posts by this user Quote this message in a reply
Post Reply  Post Thread 

Possibly Related Threads...
Thread: Author Replies: Views: Last Post
  About Microsoft 2003 Suite/re-installations? earleneshelmire 1 6 11-28-2007 12:12 AM
Last Post: earleneshelmire
  how can i create this computer song into my... sexxsy 1 1 09-24-2007 04:24 PM
Last Post: sexxsy
  microsoft office language settings -... Can C 1 0 09-19-2007 01:58 PM
Last Post: Can C
  I have downloaded updates from microsoft for... vas 1 0 09-14-2007 01:40 AM
Last Post: vas
  how to disable the Microsoft UAA Bus Driver... chiki 1 1 09-12-2007 12:54 PM
Last Post: chiki
  Using MS Visual Studio to create a .msi for my... Rizzeich 1 0 09-10-2007 06:29 PM
Last Post: Rizzeich
  Problems with microsoft office 07 installation? mystery_girl 1 1 09-04-2007 09:15 AM
Last Post: mystery_girl
  I just purchased the new version of Microsoft Office dutch94199 1 0 07-29-2007 09:23 AM
Last Post: dutch94199
  Does Microsoft steal ideas from Macintosh? Batman 15 14 05-26-2007 11:54 AM
Last Post: xtremesniper
  where can I get a link to download microsoft IE7.0? oprf71 9 3 05-26-2007 11:54 AM
Last Post: durky

View a Printable Version
Send this Thread to a Friend
Subscribe to this Thread | Add Thread to Favorites

Forum Jump: