Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Test if an element of array is empty
How can I test if .aryPartDes(2) has something in it? Note: PartInfo() is a
function, where it looks up the part number "UVOvercoat", and stores a 1 x 4 Range in .aryPartDes(2). If nothing is assigned to .aryPartDes(2) then I get an error indicated below. Any ideas? ' formetco UV overcoat material If chkUVOvercoat.Enabled And chkUVOvercoat Then .aryPartDes(2) = PartInfo("UVOvercoat") .aryPartQty(2) = .TrimSqFt * Val(tbxQuantity) End If ' must have minimum $175 order each face: material + overcoat ERROR If .aryPartDes(2) = Empty Then If .TrimSqFt * (.aryPartDes(1)(1, 4) + .aryPartDes(2)(1, 4)) < 175 Then .aryPartDes(1) = PartInfo("FormetcoMinPrice") .aryPartQty(1) = Val(tbxQuantity) Erase .aryPartDes(2) .aryPartQty(2) = 0 End If Else If .TrimSqFt * .aryPartDes(1)(1, 4) < 175 Then .aryPartDes(1) = PartInfo("FormetcoMinPrice") .aryPartQty(1) = Val(tbxQuantity) End If End If -- Cheers, Ryan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rules for element-by-element product in array multiplication | Excel Programming | |||
Can I test dynamic array for empty? | Excel Programming | |||
Array problem: Key words-Variant Array, single-element, type mismatch error | Excel Programming | |||
Can't test for Empty objects in an array | Excel Programming | |||
Set array element to empty | Excel Programming |