Re: Selecting The Last Row
- From: Minitman <exreply@xxxxxxxxxxxxxxx>
- Date: Wed, 20 Jul 2005 11:29:42 -0500
Hey James,
My data starts not in A2 but in A<LastRow>.
It looks like Bob's solution might be a bit better for what I am
trying to do, which is add two more conditions without using CFPlus to
change those few rows that need them.
Thanks for the assistance
-Minitman
On 19 Jul 2005 20:56:44 -0700, james.billy@xxxxxxxxx wrote:
>Hi,
>
>You could do something like setting the last row to a variable and then
>using that. For example:
>
>Endrow = Range("A65536").end(xlup).row
>Range("A2:W" & Endrow).Select
>
>Another way to do it is to select the current region for example:
>
>Range("A2").CurrentRegion.select
>
>The current region is the same as the short cut key ctrl + *.
>
>Both of the examples assume your data starts in cell A2.
>
>Any problems then give me a shout.
>
>James
.
- References:
- Selecting The Last Row
- From: Minitman
- Re: Selecting The Last Row
- From: james . billy
- Selecting The Last Row
- Prev by Date: Date format
- Next by Date: Re: Application events
- Previous by thread: Re: Selecting The Last Row
- Next by thread: Re: Selecting The Last Row
- Index(es):
Relevant Pages
|
