Highlight cells with ctrl-click but only un-highlight one cell

[Guest]

When highlighting a number of cells using ctrl-click, and accidentally
highlighting one incorrectly, how can I un-highlight it without losing my
other selections and starting over?

 

[Paul B]

Hagan, have a look here for some code to do it,

http://www.google.com/groups?threadm=#[email protected]
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Guest]

Paul,

Thanks for the link. However, I'm at the point that BillB got to, where
he said he couldn't find the personal.xls file and then how do you edit the
Workbook_Open procedure?

Hagan

 

[Paul B]

hagan, have a look here on getting started with Macros on David McRithchie's
site
http://www.mvps.org/dmcritchie/excel/getstarted.htm
If you need anymore help post back
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Guest]

Paul,

Whew! That was pretty deep considering that I've never written a macro or
used VBA. Finally got it working, and it's great. Thanks a lot for your
help. Sorry I had to keep asking for instructions.

Hagan

 

[Paul B]

hagan, no problem, glad you got it working
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003