Roger, there was a thread just last week about a program to highlight a row when the Selection changes; I think it was a pretty simple Worksheet_Change subroutine. If that's what you're using, then all you need is a statement at the beginning that if the target is in the first row or column, the program should end immediately rather than continue. What does your program code look like now?
|