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

Thread: Is there a way to automatically highlight the column and the row that of the current

View Single Post

Old

02-13-2012, 02:16 AM

Colin Legg Colin Legg is offline

Colin Legg is offline

Colin Legg uses Windows 7 32bit

Windows 7 32bit Colin Legg uses Office 2010 32bit

Colin Legg uses Office 2010 32bit

Office 2010 32bit

Expert

Join Date: Jan 2011

Location: UK

Posts: 369

Colin Legg will become famous soon enough

Default

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.

Reply With Quote