| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Weird double selection
I have a sub that after it runs, one cell remains permanently
selected, but you can select other cells too. But it looks different from when you hold down 'Ctrl' and do multiple selections. The other selected cells are not colored in, just black border around them. Has anyone else encountered this problem? Any suggestions? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Weird double selection
Does your routine do any cell border formatting or use the SendKeys method
that turns on the selection modes (F8 = Extend current selection, Shift+F8 = Add to current selection)? Maybe a snippet of the code would help. ______________________ Robert Rosenberg R-COR Consulting Services Microsoft MVP-Excel "Wexler" wrote in message om... I have a sub that after it runs, one cell remains permanently selected, but you can select other cells too. But it looks different from when you hold down 'Ctrl' and do multiple selections. The other selected cells are not colored in, just black border around them. Has anyone else encountered this problem? Any suggestions? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Weird double selection
Scroll down & back up. It's a refresh anomaly.
"Wexler" wrote in message om... I have a sub that after it runs, one cell remains permanently selected, but you can select other cells too. But it looks different from when you hold down 'Ctrl' and do multiple selections. The other selected cells are not colored in, just black border around them. Has anyone else encountered this problem? Any suggestions? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Weird double selection
More often than not, its not necessary to actually select
a cell in order to use it... Range("A1").select selection.value = 10 can be re-written Range("A1").Value = 10 Similarly, with a range... With Range("G5:K10") .Interior.Colorindex = 34 With .Columns(1) .Font.Bold = True .Interior.Colorindex = 14 End With End With Patrick Molloy Microsoft Excel MVP -----Original Message----- I have a sub that after it runs, one cell remains permanently selected, but you can select other cells too. But it looks different from when you hold down 'Ctrl' and do multiple selections. The other selected cells are not colored in, just black border around them. Has anyone else encountered this problem? Any suggestions? . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Limiting selection in a cell AND linking that selection to a list | Excel Discussion (Misc queries) | |||
| How to use selection change instead of double click event? | Excel Discussion (Misc queries) | |||
| Copy Selection - Transpose Selection - Delete Selection | Excel Discussion (Misc queries) | |||
| Identifying a selection of a selection of a range | Excel Worksheet Functions | |||
| double axis, double problem (i hope only to me) | Charts and Charting in Excel | |||
Linear Mode
