| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Top left cell in used range
Hi,
can somebody tell me how to find the address of the top left cell for the used range on a worksheet..?? Sorry, I know this is trivial... Chris |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Top left cell in used range
|
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Top left cell in used range
One way:
Dim sAddress As String sAddress = ActiveSheet.UsedRange.Cells(1).Address In article , "Chris Gorham" wrote: Hi, can somebody tell me how to find the address of the top left cell for the used range on a worksheet..?? Sorry, I know this is trivial... Chris |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Top left cell in used range
ActiveSheet.UsedRange.Cells(1,1).Address
HTH Paul -------------------------------------------------------------------------------------------------------------- Be advised to back up your WorkBook before attempting to make changes. -------------------------------------------------------------------------------------------------------------- Hi, can somebody tell me how to find the address of the top left cell for the used range on a worksheet..?? Sorry, I know this is trivial... Chris |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Top left cell in used range
or even
Activesheet.UsedRange.Item(1).Address or ActiveSheet.UsedRange.Item(1,1).Address -- Regards, Tom Ogilvy "Chris Gorham" wrote in message ... Hi, can somebody tell me how to find the address of the top left cell for the used range on a worksheet..?? Sorry, I know this is trivial... Chris |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| populating new cell with first populated cell to the left | Excel Worksheet Functions | |||
| How to select a cell to the left of the right aligned cell with th | Excel Discussion (Misc queries) | |||
| Fill down formulas in cells to the LEFT of external data range? | Excel Worksheet Functions | |||
| How to point to (select) a cell to the left from a cell where I enter the = equal sign? | Excel Discussion (Misc queries) | |||
| Set a 2D arrray data into a range, given the top-left cell | Excel Discussion (Misc queries) | |||
![Chris Gorham[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
