Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Syntax problem with" intersect"
Hello All, I hope someone is still active despite the weekend...
I get a error message " The argument is not "free of choice" (or what it will be like in an english version) and the .Intersect. command highlighted. (sorry about the double "not" in sentence "Not .. Is Nothing...) Here is a extract of the code: Private Sub Worksheet_Change(ByVal Target As Range) .... ActRow = Target.Row ActCol = Target.Column If Not ActiveSheet.Intersect.Range("A6:A25, A29:A48, A52:A94") Is Nothing Then ' HERE !!! If Application.Range(Cells(ActRow, ActCol)).Value = "" Then If Application.Range(Cells(ActRow, ActCol + 1)).Value = "" Then End If If Application.Range(Cells(ActRow, ActCol + 1)).Value < "" Then MsgBox "DuhmDiduhm DaDiDo" End If End If If Not Application.Intersect.Range("B6:B25, B29:B48, B52:B94") Is Nothing Then If Application.Range(Cells(ActRow, ActCol)).Value = "" Then If Application.Range(Cells(ActRow, ActCol - 1)).Value = "" Then End If If Application.Range(Cells(ActRow, ActCol - 1)).Value < "" Then Application.Range(Cells(ActRow, ActCol - 1)).Value = 0 End If Any suggestions? What is wrong with Intersect syntax? /regards |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Syntax problem with" intersect"
Hi
this looks like a wrong syntac. I assume you want to test if the changed range target is within A1:A25, A29:A48 or A52:A94 try something like the following: Private Sub Worksheet_Change(ByVal Target As Range) Dim test_range set test_range=union(me.range("A1:A25"),me.range("A29: A45"),me.range("A52:A 94")) if not intersect(target,test_range) is nothing then 'now your code end sub -- Regards Frank Kabel Frankfurt, Germany Imbecill wrote: Hello All, I hope someone is still active despite the weekend... I get a error message " The argument is not "free of choice" (or what it will be like in an english version) and the .Intersect. command highlighted. (sorry about the double "not" in sentence "Not .. Is Nothing...) Here is a extract of the code: Private Sub Worksheet_Change(ByVal Target As Range) ... ActRow = Target.Row ActCol = Target.Column If Not ActiveSheet.Intersect.Range("A6:A25, A29:A48, A52:A94") Is Nothing Then ' HERE !!! If Application.Range(Cells(ActRow, ActCol)).Value = "" Then If Application.Range(Cells(ActRow, ActCol + 1)).Value = "" Then End If If Application.Range(Cells(ActRow, ActCol + 1)).Value < "" Then MsgBox "DuhmDiduhm DaDiDo" End If End If If Not Application.Intersect.Range("B6:B25, B29:B48, B52:B94") Is Nothing Then If Application.Range(Cells(ActRow, ActCol)).Value = "" Then If Application.Range(Cells(ActRow, ActCol - 1)).Value = "" Then End If If Application.Range(Cells(ActRow, ActCol - 1)).Value < "" Then Application.Range(Cells(ActRow, ActCol - 1)).Value = 0 End If Any suggestions? What is wrong with Intersect syntax? /regards |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Syntax problem with" intersect"
If Not Intersect(Target,me.Range("A6:A25, A29:A48, A52:A94")) Is _
Nothing Then If Not Intersect(Target,Range("B6:B25, B29:B48, B52:B94")) Is _ Nothing Then -- Regards, Tom Ogilvy "Imbecill" wrote in message ... Hello All, I hope someone is still active despite the weekend... I get a error message " The argument is not "free of choice" (or what it will be like in an english version) and the .Intersect. command highlighted. (sorry about the double "not" in sentence "Not .. Is Nothing...) Here is a extract of the code: Private Sub Worksheet_Change(ByVal Target As Range) ... ActRow = Target.Row ActCol = Target.Column If Not ActiveSheet.Intersect.Range("A6:A25, A29:A48, A52:A94") Is Nothing Then ' HERE !!! If Application.Range(Cells(ActRow, ActCol)).Value = "" Then If Application.Range(Cells(ActRow, ActCol + 1)).Value = "" Then End If If Application.Range(Cells(ActRow, ActCol + 1)).Value < "" Then MsgBox "DuhmDiduhm DaDiDo" End If End If If Not Application.Intersect.Range("B6:B25, B29:B48, B52:B94") Is Nothing Then If Application.Range(Cells(ActRow, ActCol)).Value = "" Then If Application.Range(Cells(ActRow, ActCol - 1)).Value = "" Then End If If Application.Range(Cells(ActRow, ActCol - 1)).Value < "" Then Application.Range(Cells(ActRow, ActCol - 1)).Value = 0 End If Any suggestions? What is wrong with Intersect syntax? /regards |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
correct syntax for nesting "if", "and", and "vlookup"....if possib | Excel Worksheet Functions | |||
Syntax to "OR" 3 "ISERROR" conditions | Excel Worksheet Functions | |||
disregard 12/19/05 ".XValues syntax problem" question. Answer fou | Charts and Charting in Excel | |||
what is syntax for if(between range of dates,"Q1","Q2")? | Excel Worksheet Functions |