; when you open the file, xlLastCell will then be 1000...
>
> There are more ways (many more than I care to enumerate!)
>
> Basically, you need to select your poison.
> You need to determine the last cell based on YOUR requirements,
> then you can select them.
>
> good luck,
>
ements,
> then you can select them.
>
> good luck,
>
> Paul
>
>
> From: Tommy
> To: MS EXCEL AND VBA MACROS
> Sent: Wed, November 11, 2009 10:03:27 AM
> Subject: $$Excel-Macros$$ cell selection
>
> In a macro, I would like to be a
In a macro, I would like to be able to select a group of contiguous
cells containing information, where I know the location of the first
cell but not the location of the last cell in the group. I also know
that the only cells in the column containing information are in the
group of cells to be sel
