Tom:
Thanks for saying "Entering a value in the active cell only produced a one
cell target even with multiple cells selected." That is very meaningful.
Dave and your explanation have assisted me greatly...
JMay

"Tom Ogilvy" wrote in message
...
I didn't suggest this action would fire an event. I just answered how to
change the activecell in a multi-cell selection.

for me, it fires neither change or selectionchange. Entering a value in
the
active cell only produced a one cell target even with multiple cells
selected. Using Daves suggestion (multicell entry), it did fire a
multicell
target (as expected). Deleting multiple cells did produce a multicell
target (as expected).

--
Regards,
Tom Ogilvy

"JMay" wrote in message
news:2Vqlc.3783$nN6.1057@lakeread06...
Thks Tom, yeah I'd forgotten that (tidbit)!
So now that I go back and "tab" I see my activecell change
But no MsgBox

Using:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count 1 Then
MsgBox ("Statement is True")
End If
End Sub

What now?

"Tom Ogilvy" wrote in message
...
Hitting Tab will change the active cell within the selection.

--
Regards,
Tom Ogilvy

"JMay" wrote in message
news:Esqlc.3780$nN6.2939@lakeread06...
Bob:

If I select more than one cell in my spreadsheet,
Let's say my cursor is in cell B1 and I drag over cells
to D5 (B1:D5 now selected) I'm unable to change the active cell,
Right?
Are you talking about changing the active cell via code?
TIA,
JMay

"Bob Phillips" wrote in message
...
Only selecting more than one cell and then changing the active
cell
to
trigger the event.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"JMay" wrote in message
news:Jcflc.3306$nN6.50@lakeread06...
Using
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count 1 Then Exit Sub

What kind of things (list most obvious) can happen to make this
statement
TRUE?
TIA,