Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
select last cell in used range
Hi all, How do I select the last (right, bottom) cell in a used range. Have played with the Range(ActiveSheet.UsedRange.Cells (?).Address).Select - with no luck. Any help would be appreciated. Tony. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
select last cell in used range
Hi Tony,
Short snippet example: Dim lastcell As Range Set lastcell = Cells.SpecialCells(xlLastCell) lastcell.EntireRow.Select The following single line of code should do what you asked: cells.specialcells(xlLastCell).activate -- --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Tony P" wrote in message ... Hi all, How do I select the last (right, bottom) cell in a used range. Have played with the Range(ActiveSheet.UsedRange.Cells (?).Address).Select - with no luck. Any help would be appreciated. Tony. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Select range of cells from A1 to last cell with data? | Excel Discussion (Misc queries) | |||
how can I select a range of cells based on a value of a cell? | Excel Discussion (Misc queries) | |||
select first cell in unmerged range | Excel Discussion (Misc queries) | |||
How to select a range whose name is entered in a cell. | Excel Worksheet Functions | |||
using cell values to select range of cells | Excel Programming |