LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default HIDE-UNHIDE VBA MACRO

Hi,
I am trying to build a VBA Macro to Hide-Unhide rows that does not
contain a value in a specific column of my sheet. I would like to do it
automaticaly without me having to play a macro. I have a VLOOKUP in the
cells I want evaluated so if I enter data on another tab it would
automatically fill in the data, which in return will automatically unhide the
row that has the new data or hide the row where the data is removed. I hope
this makes sence. Is there a way to do this?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro that will unhide then hide rows minka Excel Discussion (Misc queries) 10 October 21st 06 01:37 PM
hide/unhide macro Matt Excel Discussion (Misc queries) 2 April 6th 06 07:24 PM
hide/unhide row macro Checkman Excel Programming 4 January 20th 06 09:46 PM
hide/unhide macro zenahs[_3_] Excel Programming 2 November 10th 05 06:37 PM
Hide/Unhide Macro bug Dave[_28_] Excel Programming 1 September 4th 03 06:26 PM


All times are GMT +1. The time now is 09:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"