Single or Multiple Cell Selection

[PosseJohn]

Greetings...
I have a WS that contains code under 'Private Sub Worksheet_Change(ByVal
Target As Range)'

I only want to run the code if the user is changing contents of a single cell.

How do you detect if the user has selected multiple cells or not?

[Gord Dibben]

If Target.Count > 1 Then Exit Sub 'or whatever


Gord Dibben Excel MVP

On Sun, 27 Nov 2005 09:17:19 -0800, PosseJohn
<[email protected]> wrote:

>Greetings...
>I have a WS that contains code under 'Private Sub Worksheet_Change(ByVal
>Target As Range)'
>
>I only want to run the code if the user is changing contents of a single cell.
>
>How do you detect if the user has selected multiple cells or not?

[PosseJohn]

THANX Gord, sometimes the easiest way isn't always obvious.

"Gord Dibben" wrote:

> If Target.Count > 1 Then Exit Sub 'or whatever
>
>
> Gord Dibben Excel MVP
>
> On Sun, 27 Nov 2005 09:17:19 -0800, PosseJohn
> <[email protected]> wrote:
>
> >Greetings...
> >I have a WS that contains code under 'Private Sub Worksheet_Change(ByVal
> >Target As Range)'
> >
> >I only want to run the code if the user is changing contents of a single cell.
> >
> >How do you detect if the user has selected multiple cells or not?
>
>