Microsoft Office Forums - View Single Post - Is there a way to automatically highlight the column and the row that of the current

Jamal NUMAN · 02-13-2012, 01:22 PM

Quote:

Originally Posted by Colin Legg

Since you're using Excel 2010, you should probably change this line:

Code:

If Target.Cells.Count > 1 Then Exit Sub

To this:

Code:

If Target.Cells.CountLarge > 1 Then Exit Sub

Otherwise, if the user selected all of the cells on the sheet you will get a runtime overflow error.

Thank you Colin for the contribution.

i didn't find any problem with the code provided by zyzzyva57

please have a look on the attached screenshot. the code is working very well on the Excel 2010.

regards

Jamal