| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
looking for a function
is there a function that locate me at the last writed cell in a column (I
thought about: sendkeys ^ {end} but with this it goes to the last column and row) also the same function but for rows pd. I want functions, sendkeys works but I don't like to use it because the structure of the program is difficult to understand with sendkeys.... TIA |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
looking for a function
A specific example:
Range("I1").End(xldown).Select A second possible answer: Activecell.End(xlDown).Select Third: Cells(65536,Activecell.Column).End(xlUp).Select "filo666" wrote: is there a function that locate me at the last writed cell in a column (I thought about: sendkeys ^ {end} but with this it goes to the last column and row) also the same function but for rows pd. I want functions, sendkeys works but I don't like to use it because the structure of the program is difficult to understand with sendkeys.... TIA |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
looking for a function
no, but I mean going to the last cell, if you have 1 2 3 4 5 6 your codes
goes until 3 then to 4 and then to 6, I want onw code that when is executed it goes to the really las cell (6) "frankt" wrote: A specific example: Range("I1").End(xldown).Select A second possible answer: Activecell.End(xlDown).Select Third: Cells(65536,Activecell.Column).End(xlUp).Select "filo666" wrote: is there a function that locate me at the last writed cell in a column (I thought about: sendkeys ^ {end} but with this it goes to the last column and row) also the same function but for rows pd. I want functions, sendkeys works but I don't like to use it because the structure of the program is difficult to understand with sendkeys.... TIA |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
looking for a function
filo
Sub test1() ''find last cell in active column ActiveSheet.Cells(Rows.Count, ActiveCell.Column).End(xlUp).Select End Sub Gord Dibben Excel MVP On Mon, 11 Apr 2005 12:15:03 -0700, "filo666" wrote: is there a function that locate me at the last writed cell in a column (I thought about: sendkeys ^ {end} but with this it goes to the last column and row) also the same function but for rows pd. I want functions, sendkeys works but I don't like to use it because the structure of the program is difficult to understand with sendkeys.... TIA |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
| Adding a custom function to the default excel function list | Excel Programming | |||
Linear Mode
