Re: Highlight a row

Tech-Archive recommends: Fix windows errors by optimizing your registry

You may be able to mess around with an event macro, but those will usually
destroy the undo stack, too.



James wrote:

Not quite what I was looking for but I have seen this add in, it is very cool
but it does make the undo option unavailable.

The shift + spacebar I already knew, but I was looking for a shortcut to
change the color of the cell and row (i.e. yellow or green). I just don't
like to use the mouse to much.

Thanks,
James

"Dave Peterson" wrote:

Shift spacebar will select the rows in the area with the activecell.

You may want to try Chip Pearson's Rowliner:
http://www.cpearson.com/excel/RowLiner.htm

James wrote:

is there a keyborad shortcut to highlight the active row you are on?

Thanks

--

Dave Peterson


--

Dave Peterson
.

Relevant Pages

  • Re: Autofilter Row Count
    ... "James" wrote: ... "Dave Peterson" wrote: ... Dim wShData As Worksheet ... On Error GoTo 0 ...
    (microsoft.public.excel.programming)
  • Re: Disable Autosave
    ... It saves at times I don't want to save and it kills the Undo stack. ... > frustrating. ... Dave Peterson ...
    (microsoft.public.excel.misc)
  • Re: How to load a PDF using Excel VBA
    ... (Did you include the complete path when you tested the Start suggestion?) ... > Ahhh. ... > James wrote: ... > Dave Peterson ...
    (microsoft.public.excel.programming)