| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
A better CTRL A select
Hello What is the code that would scan rows for values, and then start ro selection on row1 to the end of the rows that doesn't have any value below it? Thanks -- Ambrosi ----------------------------------------------------------------------- Ambrosia's Profile: http://www.excelforum.com/member.php...fo&userid=2814 View this thread: http://www.excelforum.com/showthread.php?threadid=48011 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
A better CTRL A select
ctrl-home to put the cursor in cell A1. Then shift-ctrl-end to selec to the last used row and last used column. Does that help -- MrShort ----------------------------------------------------------------------- MrShorty's Profile: http://www.excelforum.com/member.php...fo&userid=2218 View this thread: http://www.excelforum.com/showthread.php?threadid=48011 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CTRL+A for Select All giving error | Excel Discussion (Misc queries) | |||
| Using CTRL to select cells for a formula | Excel Worksheet Functions | |||
| does ctrl f select cells randomly? | Excel Discussion (Misc queries) | |||
| ctrl select not working in 07 | Excel Discussion (Misc queries) | |||
| Ctrl Key to Select Cells | Excel Discussion (Misc queries) | |||
![Ambrosia[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
