Andreas Hermle
asked on
select noncontiguous rows in a table using VBA
Dear Experts:
for some specfic reasons I would like ...
... (1) to select all the rows (of the only table in the current document) where there is an entry in Column A. and alternatively
... (2) to select all the rows where there is no entry in Column C
Most of the rows selected will be non-contiguous then.
Hope this is feasible.
Thank you very much in advance.
Regards, Andreas
for some specfic reasons I would like ...
... (1) to select all the rows (of the only table in the current document) where there is an entry in Column A. and alternatively
... (2) to select all the rows where there is no entry in Column C
Most of the rows selected will be non-contiguous then.
Hope this is feasible.
Thank you very much in advance.
Regards, Andreas
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hi Andreas,
What are you planning to do once all rows are selected? If you want to apply some sort of formatting, that can be done on a row by row basis.
Paul
for some specfic reasons I would like ...
What are you planning to do once all rows are selected? If you want to apply some sort of formatting, that can be done on a row by row basis.
Paul
ASKER
Hi Paul,
thank you very much for your answer. As a matter of fact, I found a workaround for my problem. Thank you anyways.
Regards, Andreas
thank you very much for your answer. As a matter of fact, I found a workaround for my problem. Thank you anyways.
Regards, Andreas
ASKER
thank you very much for your comment. About ten minutes ago I happened to read a forum post on that subject by a Word MVP who said the same thing.
Thank you very much.
Regards, Andreas