Weird double selection

  • Thread starter Thread starter Wexler
  • Start date Start date
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?
 
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
 
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
 
Back
Top