Highlighting a Row
 

My Question is: as I data imput down a column(of multiple columns) can it
highlight the whole row so that I can be sure it is the right cell?

Highlighting a Row
 

right click sheet tabview codeinsert thissave
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells.Interior.ColorIndex = xlColorIndexNone
Target.EntireRow.Interior.ColorIndex = 36
End Sub


--
Don Guillett
SalesAid Software

"Fufu" wrote in message
...
My Question is: as I data imput down a column(of multiple columns) can it
highlight the whole row so that I can be sure it is the right cell?

Highlighting a Row
 

You should see the row number and column letter highlighted,
but if you want to hightlight the row and column itself you can use
a macro, or a bit less of a problem if you already have shading
on cells would be to highlight the borders see Chip Pearson's
Row liner (addin)
http://www.cpearson.com/excel/RowLiner.htm
as with any macro solution you lose the ability to use Undo (Ctrl+Z) so
that is a very big trade off.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Fufu" wrote in message ...
My Question is: as I data imput down a column(of multiple columns) can it
highlight the whole row so that I can be sure it is the right cell?