Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How To: Get Last Cell
Using those special cells is a bit like using the F5
(GoTo) key, and thus fires the selection change event. If you want the last cell in a column Set rgeEnd = Range("A1").End(xlDown) OR Set rgeEnd = Range("A65000").End(xlUp) which I prefer as it means we don't worry about gaps in the column. If you must use the special cells then try this Application.EnableEvents = False Set rgeEnd = Cells.SpecialCells(xlCellTypeLastCell) Application.EnableEvents = True Patrick Molloy Microsoft Excel MVP -----Original Message----- Hi, I currently use Set rgeEnd = xlsheet.Cells.SpecialCells (xlCellTypeLastCell) but for some reason the event SheetSelectionChange triggers so how do I get the range of the last cell (bottom right cell) in a sheet without using the SpecialCells xlCellTypeLastCell. regards KM . |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How To: Get Last Cell
Hi,
I solved the problem by checking to see if the form was visibl or not eg. if frmAddEditRecord.Visible Then Exit Sub but I do call the same xlSpecial cells to show a print preview so I've used your suggestion and placed Application.EnableEvents = False or true around the set rgeEnd. Thanks again regards KM -----Original Message----- Using those special cells is a bit like using the F5 (GoTo) key, and thus fires the selection change event. If you want the last cell in a column Set rgeEnd = Range("A1").End(xlDown) OR Set rgeEnd = Range("A65000").End(xlUp) which I prefer as it means we don't worry about gaps in the column. If you must use the special cells then try this Application.EnableEvents = False Set rgeEnd = Cells.SpecialCells(xlCellTypeLastCell) Application.EnableEvents = True Patrick Molloy Microsoft Excel MVP -----Original Message----- Hi, I currently use Set rgeEnd = xlsheet.Cells.SpecialCells (xlCellTypeLastCell) but for some reason the event SheetSelectionChange triggers so how do I get the range of the last cell (bottom right cell) in a sheet without using the SpecialCells xlCellTypeLastCell. regards KM . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing Options | Excel Discussion (Misc queries) | |||
Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing | Excel Discussion (Misc queries) | |||
Populate a cell if values in cell 1 and cell 2 match cell 3 and 4 | Excel Worksheet Functions | |||
How to create/run "cell A equals Cell B put Cell C info in Cell D | Excel Discussion (Misc queries) | |||
Question: Cell formula or macro to write result of one cell to another cell | Excel Programming |