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

		Microsoft Office Forums > Microsoft Excel > Excel
Is there a way to automatically highlight the column and the row that of the current

02-13-2012, 02:16 AM

Colin Legg Colin Legg is offline

Windows 7 32bit Is there a way to automatically highlight the column and the row that of the current

Office 2010 32bit

Expert

Join Date: Jan 2011

Location: UK

Posts: 369

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can I change the horizontal scrollbar to scroll smoothly rather than column by column	carpat	Excel	0	01-10-2012 09:34 AM
How to call current PC date and/or current PC year	KIM SOLIS	Excel	2	11-04-2011 06:09 PM
Current view filter applies automatically	lumisy	Outlook	3	03-25-2011 05:44 AM
Auto insert current month's name and current year	Styler001	Word	4	01-25-2010 06:40 PM
find - reading highlight - highlight all / highlight doesn't stick when saved	bobk544	Word	3	04-15-2009 03:31 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:53 PM.