Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting a range with the last used cell?
Simple answer im sure but it is Friday!!!!
Hi, Im trying to select a range. i.e Range("A1:A23456").select however, the last cell will change as the range grows. I need to fin the last used cell for my range to replace A23456 everytime I run th macro. Can someone quickly write me the code to find the last cell for m range? Cheers. And -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting a range with the last used cell?
Andy,
Try UsedRange it returns A1 to the bottom right of the active sheet Trev -----Original Message----- Simple answer im sure but it is Friday!!!! Hi, Im trying to select a range. i.e Range("A1:A23456").select however, the last cell will change as the range grows. I need to find the last used cell for my range to replace A23456 everytime I run the macro. Can someone quickly write me the code to find the last cell for my range? Cheers. Andy --- Message posted from http://www.ExcelForum.com/ . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting a range with the last used cell?
andy
Sub selectrange2() ''from top of column A to bottom of used range in column A including blanks Range("A1").Select Range(ActiveCell, Cells(Rows.Count, ActiveCell.Column).End(xlUp)).Select End Sub Sub selectrange1() ''from activecell in any column to bottom of used range in column including ''blanks Range(ActiveCell, Cells(Rows.Count, ActiveCell.Column).End(xlUp)).Select End Sub Gord Dibben Excel MVP On Fri, 2 Jul 2004 08:37:37 -0500, andycharger wrote: Simple answer im sure but it is Friday!!!! Hi, Im trying to select a range. i.e Range("A1:A23456").select however, the last cell will change as the range grows. I need to find the last used cell for my range to replace A23456 everytime I run the macro. Can someone quickly write me the code to find the last cell for my range? Cheers. Andy --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Addin:Setting the range to the Excel.Range object range prop | Excel Worksheet Functions | |||
VBA setting Range | Excel Discussion (Misc queries) | |||
Setting a range value to the last cell in active worksheet. | Excel Programming | |||
Setting a Range | Excel Programming | |||
range setting | Excel Programming |