| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
changing a SendKeys "(^+{home})" to a function
look the folowing code atached:
Cells(1, 1).Select ActiveSheet.Cells(Rows.Count, ActiveCell.Column).End(xlUp).Select ActiveCell.EntireRow.Select SendKeys "(^+{home})" I want to change the sendkey line to a function (the send key press control+shift+home so it selects tall the rows from the bottom to the beginning of the sheet) TIA. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I stop "global" hyperlinks changing to "local" links? | Excel Worksheet Functions | |||
| Excel: Changing "numeric $" to "text $" in a different cell. | Excel Worksheet Functions | |||
| Changing "returned" values from "0" to "blank" | Excel Worksheet Functions | |||
| sendkeys "^v" behavior changed with the office 2003 version? | Excel Programming | |||
| SENDKEYS change the "Number Lock" status | Excel Programming | |||
Threaded Mode
