<a
href="http://msdn.microsoft.com/newsgroups/default.aspx?query=gerstman&dg=microsoft.public.ex cel.programming&cat=en-us-msdn-officedev-excel&lang=en&cr=US&pt=f3f7ac8a-4ea0-4c36-bed9-8feae6d75298&catlist=B7714BAA-0D60-40B0-A226-8B9CF33299A5%2C774F24A2-F71F-425F-AC2B-DC48AB0DA5C9&dglist=&ptlist=&exp=&sloc=en-us"Earlier</a I asked about defining a range for non-contiguous data.

The answer involved going to the bottom of the page and then using xlUp to
hit the last row of data. Like this:

Set poc_range = ActiveSheet.Range("b2", Cells(Rows.Count, 2).End(xlUp))

Now what I'd like to do is something similar. I'd like to be able to get a
range that covers <strongboth</strong the rows and columns and then select
it. Is that possible, or can I only specify one direction at a time?

David