Defining a range to highlight column and row in line with selected cell

[ACM2]

Right, I have this useful piece of code I found. Whatever cell the user clicks, it highlights all the column and row cells in line with the selected cell, making it ideal for use in large tables (so you can easily see the column and row entry).

The problem is, it works anywhere on the active worksheet, how can I make it so it only works on a range of cells within the worksheet.

Please Login or Register  to view this content.

highlight-active-cell.xls

[protonLeah]

Please Login or Register  to view this content.