-
Data Validation formula issues
Hi Folks
I'm trying to set up a data validation formula via VBA. That should not be too difficult, however, it is, acutally to me.
Basically I just want to allow x or empty ("") values to be allowed in a certain range.
With that range, I've been trying like so:
with myrange
With .Validation
.Delete
.Add Type:=xlValidateCustom, AlertStyle:=xlValidAlertStop, Operator:= _
xlBetween, Formula1:="=WENN(ODER(D4= ""x"";D4 ="""");WAHR;FALSCH)"
end with
end with
This works for the cell D4 then only, but how do i get this to work for the whole range...let's say D4:E100
Any help very welcome, cheers
-
Solved it myself
Formula1:="""x"";"""""
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules