excel sheet ranges

  • Thread starter Thread starter GS
  • Start date Start date
G

GS

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
 
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.
 
thanks
Nicholas Paldino said:
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.


--
- Nicholas Paldino [.NET/C# MVP]
- (e-mail address removed)

GS said:
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
Click to expand...
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA set thick borders around non empty cells in range 0
Excel VBA 1
Excel Msgbox runing beyond posted cell range. 1
Excel Need assistance with modifying a Duplicate declaration. 13
Excel How to run multiple Private Sub Worksheet_Change(ByVal Target As Range) 0
Create Sheets from a Range and Copy Data on copy Data on newlycreated Sheets with the Sheet Names 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Copy a range data from 1 sheet to multiple selected sheets 1

Back
Top