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?

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?

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?

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?
.