Hi,
Having found out how to perform the small miracle that is highlighting the
active row in an Excel spreadsheet at:
http://www.mcgimpsey.com/excel/highlightrow.html
I find I know have a small problem.
The row that is active when the spreadsheet is opened does not reset back to
the previous formatting. This means that although when I click on a different
row it becomes highlighted, changes back when I click to another, etc, the
original row selection upon opening stays highlighted too.
I have had no option but to delete the row from the sheet to remove it, but
I don't want the users of the spreadsheet to have to do this, or even attempt
to!
Does anyone have any suggestions as to what might be going wrong, what I
might have done wrong, etc?
I have inserted the code suggested into a Worksheet:Selection Change, is
this correct?
All help gladly received,
Dickie