Is Cells(1,1) a range? 1

• Jul 14, 2005

1
• #2

PHV

MIS

Nov 8, 2002

53,708

FR

A starting point:
Dim r As Range
Set r = Intersect(Target, Cells(1, 1))
If Not r Is Nothing Then MsgBox "A1 changed"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

Upvote 0 Downvote

• Jul 14, 2005

• Thread starter
• #3

markask

Programmer

Apr 28, 2005

167

GB

PHV,

Thank you for quick response.

I just not understand why we cannot use "is" for two ranges, Target and Cells(1,1)

 

Upvote 0 Downvote

• Jul 14, 2005

• #4

S

SkipVought

Programmer

Dec 4, 2001

47,492

US

Target may be DIFFERENT than Cells(1,1) yet intersects.

Skip,

_{[red]Be advised:[/red]We know Newton's 3 Laws. But did you hear about the [red]FOURTH???[/red]
Only ONE fig per cookie!}

 

Upvote 0 Downvote

• Jul 14, 2005

• Thread starter
• #5

markask

Programmer

Apr 28, 2005

167

GB

SkipVought,

Thank you. Can I:
If Target.Address = Cells(1, 1).Address

 

Upvote 0 Downvote

• Jul 14, 2005

• #6

PHV

MIS

Nov 8, 2002

53,708

FR

And what should happen if Target is, say, Range("A1:A3") ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

Upvote 0 Downvote