AnsweredAssumed Answered

vrf Porting VBA to VEE

Question asked by robert.rais on Nov 16, 2004
This works  

bob



sheet.range("a10").select;
sheet.range("a10").formatconditions.delete();
sheet.range("a10").FormatConditions.Add(xlCellValue, xlBetween,"10",
"30");    
sheet.range("a10").FormatConditions(1).interior.colorindex=50;


-----Original Message-----
From: Karpaty Dave [mailto:Dave.Karpaty@Herley.Com]
Sent: Tuesday, November 16, 2004 8:20 AM
To: VRF
Subject: [vrf] Porting VBA to VEE

Does Anyone know how to port this VBA code into Vee? I'm attempting to
conditionally format the cells in excel.

Thanks,
Dave

VBA code:

Range("A9").Select
    Selection.FormatConditions.Delete
    Selection.FormatConditions.Add Type:=xlCellValue,
Operator:=xlBetween, _
        Formula1:="10", Formula2:="30"
    Selection.FormatConditions(1).Interior.ColorIndex = 50 End Sub

Error Messages:

GET property "delete" in the referenced ActiveX object failed Error 552

An ActiveX object returned an error during SET of property "ColorIndex"
Error 553


<<Conditional Formatting.vee>>







---
You are currently subscribed to vrf as: rsb@soco.agilent.com
To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list,  email "vrf@agilent.com". 
If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".

Outcomes