| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Having an entire row highlighted as I move from cell to cell
I am entering and analyzing data within an excel spreadsheet. Sometimes, due
to the size of the document I have trouble determining what row I am looking at. Is there a way to have the row highlighted while I move from cell to cell. Ex: I am in cell R12 - entire Row 12 is highlighted, then i move to cell R13 and Row 13 becomes highlighted. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Having an entire row highlighted as I move from cell to cell
Luthdawg,
Here is a code that I googled, it seems to work just fine, however, it will remove all background coloring as it works. It will leave borders, just the fill will be removed. Place this into your VBA Editor (Alt+F11) into the ThisWorkbook Module. I would recommend that you test this on a backup copy before you implement the changes. Private Sub Worksheet_SelectionChange(ByVal Target As Range) 'right click the tab of the sheet you are working in 'and select view code 'paste this code into the sheet 'repeat for mutiple sheets 'this works but existing color formats are lost Static LastChange Application.ScreenUpdating = False If LastChange = Empty Then LastChange = ActiveCell.Address End If Range(LastChange).EntireColumn.Interior.ColorIndex = xlNone Range(LastChange).EntireRow.Interior.ColorIndex = xlNone ActiveCell.EntireColumn.Interior.ColorIndex = 15 ActiveCell.EntireRow.Interior.ColorIndex = 15 LastChange = ActiveCell.Address Application.ScreenUpdating = True End Sub Source:http://www.mrexcel.com/archive/VBA/26758.html -- --Thomas [PBD] Working hard to make working easy. "Luthdawg" wrote: I am entering and analyzing data within an excel spreadsheet. Sometimes, due to the size of the document I have trouble determining what row I am looking at. Is there a way to have the row highlighted while I move from cell to cell. Ex: I am in cell R12 - entire Row 12 is highlighted, then i move to cell R13 and Row 13 becomes highlighted. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Having an entire row highlighted as I move from cell to cell
You can always look at the ADDRESS BOX on the top left of the Window to see which cell you are currently in... "Thomas [PBD]" wrote: Luthdawg, Here is a code that I googled, it seems to work just fine, however, it will remove all background coloring as it works. It will leave borders, just the fill will be removed. Place this into your VBA Editor (Alt+F11) into the ThisWorkbook Module. I would recommend that you test this on a backup copy before you implement the changes. Private Sub Worksheet_SelectionChange(ByVal Target As Range) 'right click the tab of the sheet you are working in 'and select view code 'paste this code into the sheet 'repeat for mutiple sheets 'this works but existing color formats are lost Static LastChange Application.ScreenUpdating = False If LastChange = Empty Then LastChange = ActiveCell.Address End If Range(LastChange).EntireColumn.Interior.ColorIndex = xlNone Range(LastChange).EntireRow.Interior.ColorIndex = xlNone ActiveCell.EntireColumn.Interior.ColorIndex = 15 ActiveCell.EntireRow.Interior.ColorIndex = 15 LastChange = ActiveCell.Address Application.ScreenUpdating = True End Sub Source:http://www.mrexcel.com/archive/VBA/26758.html -- --Thomas [PBD] Working hard to make working easy. "Luthdawg" wrote: I am entering and analyzing data within an excel spreadsheet. Sometimes, due to the size of the document I have trouble determining what row I am looking at. Is there a way to have the row highlighted while I move from cell to cell. Ex: I am in cell R12 - entire Row 12 is highlighted, then i move to cell R13 and Row 13 becomes highlighted. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Having an entire row highlighted as I move from cell to cell
Another way is to use the macro at
http://www.cpearson.com/Excel/excelM...ightActiveCell "Sheeloo" wrote: You can always look at the ADDRESS BOX on the top left of the Window to see which cell you are currently in... "Thomas [PBD]" wrote: Luthdawg, Here is a code that I googled, it seems to work just fine, however, it will remove all background coloring as it works. It will leave borders, just the fill will be removed. Place this into your VBA Editor (Alt+F11) into the ThisWorkbook Module. I would recommend that you test this on a backup copy before you implement the changes. Private Sub Worksheet_SelectionChange(ByVal Target As Range) 'right click the tab of the sheet you are working in 'and select view code 'paste this code into the sheet 'repeat for mutiple sheets 'this works but existing color formats are lost Static LastChange Application.ScreenUpdating = False If LastChange = Empty Then LastChange = ActiveCell.Address End If Range(LastChange).EntireColumn.Interior.ColorIndex = xlNone Range(LastChange).EntireRow.Interior.ColorIndex = xlNone ActiveCell.EntireColumn.Interior.ColorIndex = 15 ActiveCell.EntireRow.Interior.ColorIndex = 15 LastChange = ActiveCell.Address Application.ScreenUpdating = True End Sub Source:http://www.mrexcel.com/archive/VBA/26758.html -- --Thomas [PBD] Working hard to make working easy. "Luthdawg" wrote: I am entering and analyzing data within an excel spreadsheet. Sometimes, due to the size of the document I have trouble determining what row I am looking at. Is there a way to have the row highlighted while I move from cell to cell. Ex: I am in cell R12 - entire Row 12 is highlighted, then i move to cell R13 and Row 13 becomes highlighted. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Having an entire row highlighted as I move from cell to cell
Sheelo,
This is a great code (I might actually use it for some things), but I think he didnt want to highlight that cell, but the row itself. If needed, we can amend the code to not highlight the Column. -- --Thomas [PBD] Working hard to make working easy. "Sheeloo" wrote: Another way is to use the macro at http://www.cpearson.com/Excel/excelM...ightActiveCell "Sheeloo" wrote: You can always look at the ADDRESS BOX on the top left of the Window to see which cell you are currently in... "Thomas [PBD]" wrote: Luthdawg, Here is a code that I googled, it seems to work just fine, however, it will remove all background coloring as it works. It will leave borders, just the fill will be removed. Place this into your VBA Editor (Alt+F11) into the ThisWorkbook Module. I would recommend that you test this on a backup copy before you implement the changes. Private Sub Worksheet_SelectionChange(ByVal Target As Range) 'right click the tab of the sheet you are working in 'and select view code 'paste this code into the sheet 'repeat for mutiple sheets 'this works but existing color formats are lost Static LastChange Application.ScreenUpdating = False If LastChange = Empty Then LastChange = ActiveCell.Address End If Range(LastChange).EntireColumn.Interior.ColorIndex = xlNone Range(LastChange).EntireRow.Interior.ColorIndex = xlNone ActiveCell.EntireColumn.Interior.ColorIndex = 15 ActiveCell.EntireRow.Interior.ColorIndex = 15 LastChange = ActiveCell.Address Application.ScreenUpdating = True End Sub Source:http://www.mrexcel.com/archive/VBA/26758.html -- --Thomas [PBD] Working hard to make working easy. "Luthdawg" wrote: I am entering and analyzing data within an excel spreadsheet. Sometimes, due to the size of the document I have trouble determining what row I am looking at. Is there a way to have the row highlighted while I move from cell to cell. Ex: I am in cell R12 - entire Row 12 is highlighted, then i move to cell R13 and Row 13 becomes highlighted. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Having an entire row highlighted as I move from cell to cell
Actually the rowliner link at the bottom of that link looks awesome. I'm
trying it out right now. "Thomas [PBD]" wrote: Sheelo, This is a great code (I might actually use it for some things), but I think he didnt want to highlight that cell, but the row itself. If needed, we can amend the code to not highlight the Column. -- --Thomas [PBD] Working hard to make working easy. "Sheeloo" wrote: Another way is to use the macro at http://www.cpearson.com/Excel/excelM...ightActiveCell "Sheeloo" wrote: You can always look at the ADDRESS BOX on the top left of the Window to see which cell you are currently in... "Thomas [PBD]" wrote: Luthdawg, Here is a code that I googled, it seems to work just fine, however, it will remove all background coloring as it works. It will leave borders, just the fill will be removed. Place this into your VBA Editor (Alt+F11) into the ThisWorkbook Module. I would recommend that you test this on a backup copy before you implement the changes. Private Sub Worksheet_SelectionChange(ByVal Target As Range) 'right click the tab of the sheet you are working in 'and select view code 'paste this code into the sheet 'repeat for mutiple sheets 'this works but existing color formats are lost Static LastChange Application.ScreenUpdating = False If LastChange = Empty Then LastChange = ActiveCell.Address End If Range(LastChange).EntireColumn.Interior.ColorIndex = xlNone Range(LastChange).EntireRow.Interior.ColorIndex = xlNone ActiveCell.EntireColumn.Interior.ColorIndex = 15 ActiveCell.EntireRow.Interior.ColorIndex = 15 LastChange = ActiveCell.Address Application.ScreenUpdating = True End Sub Source:http://www.mrexcel.com/archive/VBA/26758.html -- --Thomas [PBD] Working hard to make working easy. "Luthdawg" wrote: I am entering and analyzing data within an excel spreadsheet. Sometimes, due to the size of the document I have trouble determining what row I am looking at. Is there a way to have the row highlighted while I move from cell to cell. Ex: I am in cell R12 - entire Row 12 is highlighted, then i move to cell R13 and Row 13 becomes highlighted. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| check first cell in row, move entire row to sheet of that name | Excel Worksheet Functions | |||
| Highlight 1 cell in Excel & move mouse-stays highlighted - stop? | Excel Discussion (Misc queries) | |||
| I click on a cell and move the cursor the entire area highlights | Excel Discussion (Misc queries) | |||
| The Aarow keys move the entire sheet instead of to the next cell | Charts and Charting in Excel | |||
| arrow keys move entire sheet instead of cell to cell | Excel Worksheet Functions | |||
Hybrid Mode
