Is it possible to create a VBA script that automaticly hides rows or tables in excel sheets when a specific value appears in a specific cell? Any help would be greatly appreciated as I have tried to write the code myself but have no idea where to start.
Last edited by jiminic; 12-11-2006 at 11:26 PM.
Here's an example... you'll have to modify or pillage off it to suit your needs.
Scott
Please Login or Register to view this content.
for example hide row 2 if cell a1 = 1
If Cells(1, 1).Value = 1 _
Then Cells(2, 1).EntireRow.Hidden = True
not a professional, just trying to assist.....
Thank you Both!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks