'GS[_2_ Wrote:
;1611654']You can filter on -""- and remove/delete the rows that
display, then turn off the filter.


Please review point no. 2 of my post.

My *_data_needs_to_be_updated_on_a_real_time_basis_*.
Applying and removing filters is not a practically acceptable
solution.


+-------------------------------------------------------------------+
+-------------------------------------------------------------------+

Good point! I did miss that...

The only means Excel makes available to us is worksheet events. This,
of course, requires VBA which violates Point1. I'm afraid that only
leaves 'magic' which I know you won't find anywhere and so...

Good luck!<g

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion