excel sheet ranges

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

GS - 16 Jun 2007 17:05 GMT

what is the names of last cell that I can access by Control End key
actually I want to get the range for A12 and the last data cell

Reply to this Message

Nicholas Paldino [.NET/C# MVP] - 19 Jun 2007 19:14 GMT

GS,

I believe that the UsedRange property will give you the range on the
sheet which is bounded by the cells that were used which are furthest to the
right and furthest down.

Signature

- Nicholas Paldino [.NET/C# MVP]
- mvp@spam.guard.caspershouse.com

> what is the names of last cell that I can access by Control End key
> actually I want to get the range for A12 and the last data cell

Reply to this Message

GS - 20 Jun 2007 06:34 GMT

thanks

> GS,
>
[quoted text clipped - 4 lines]
> > what is the names of last cell that I can access by Control End key
> > actually I want to get the range for A12 and the last data cell

Reply to this Message

Rate this thread:

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...