Hi Dave,

It is not clear where you are headed or what you are trying to get away from.
But my guess is that you are trying to make it more generic so that it can be
used anywhere, and the use of INTERSECT would help you reduce a
section. Of course in a macro you really want to avoid changing the
actual selection on the worksheet unless that is the purpose of the macro.

See if the follow page helps helps.
.. http://www.mvps.org/dmcritchie/excel/proper.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Dave" wrote in message ...
How can the following range statment: "ActiveCell.Range("A1:A300").Select" be
written for a varialble range based on "Selection.Rows.Count" ?

Thank you
dave