Weird double selection

W

Wexler

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

Robert Rosenberg

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
 
P

Patrick Molloy

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
 
Top