| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to select / highlight entire row.
Perfect!
Thanks Mike "Mike H" wrote: Ross, Your question is contradictary. To select the entire row use Private Sub Worksheet_SelectionChange(ByVal Target As Range) ActiveCell.EntireRow.Select end sub to select columns A -Z use Private Sub Worksheet_SelectionChange(ByVal Target As Range) With ActiveCell Range(Cells(.Row, "A"), Cells(.Row, "Z")).Select End With End Sub To instal these right click your sheet tab, view code and paste the code in on the right Mike "Ross" wrote: How can I get Excel to select an entire row when I use the "Arrow UP" key or the "Arrow Down" key? For Example, if the cursor has selected Cell A3 and I "Arrow Down" to A4, the cursor would then select the ENTIRE A4 ROW (this spreadsheet has data in some of the A:Z columns (columns are not consistently filled for all cell A4:Z4). This will help the viewer see all of the A4:Z4 cells highlighted (kind of a custom user input aid). Many Thanks Ross |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to highlight an entire row if a certain value is in a cell | Excel Discussion (Misc queries) | |||
| Select and delete entire row Excel VBA macro | Excel Programming | |||
| why does this macro select the entire worksheet when run? | Excel Discussion (Misc queries) | |||
| Highlight entire rows as I scroll? | Excel Discussion (Misc queries) | |||
| Highlight the entire row of a selected cell | Excel Programming | |||
Threaded Mode
