Syntax help

[jim may]

In A Double-Click Event Macro I'm Having Syntax issues in getting the 2nd code line to "take"

Lr = Range("C" & Rows.Count).End(xlUp).Row
If Not Intersect(Target, Range("N & Target.Row & ":P" & LR)) Is Nothing Then

What's the proper syntax?

TIA,

Jim

 

[Fluff]

You're missing the closing " after the N

 

[jim may]

Thanks Fluff... so close, but "no cigar"..

 

[mikerickson]

In a DoubleClick event, Target is only one cell.
It looks like you are checking for

If (Target.Row<=LR) and (14 >= Target.Column) And (Target.Column <=16) Then

 

[DanteAmor]

If you double click on the columns from N to P, this line will always be true.

If Not Intersect(Target, Range("N" & Target.Row & ":P" & lr)) Is Nothing Then

Because if the last cell in column C

lr = Range (" C "& Rows.Count) .End (xlUp). Row

is 10 and you press double click on cell N15, the intersection range is "N15:P10" then N15 is within the range.


Maybe you want to validate only one range, for example from N2 to P & LR, try this:

    lr = Range("C" & Rows.Count).End(xlUp).Row
    If Not Intersect(Target, Range("N2:P" & lr)) Is Nothing Then

But I think we're speculating, better explain what you need.