Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |