Using Properties

There is a large and confusing number of properties VBA Help lists a total of 486 property names. The list of properties belonging to the Range object alone contains more than 40 entries. Some of the most useful properties of the Range object are listed in Table 14-1. 

Column Returns a number corresponding to the first column in the range. 

ColumnWidth Returns or sets the width of aU columns in the range. 

NumberFormat Returns or sets the format code for the range. 

RowHeight Returns or sets the height of all rows in the range. 

In a VBA macro, many times you ll need to determine the value or state of an object s property, or change it. There are two kinds of property read-only and read-write. Properties can have values that are numeric, string or logical. 

---

Perfluoroalkyl derivatives have important technical uses, e.g. sulphonic acids as surfactants introduction of perfluoroalkyl groups confers useful properties on many drugs. 

Appendix 1 comprises a series of tables giving the principal characteristics of pure components most commonly found in the petroleum industry and supplying data for calculation of some useful properties. 

Product characterization aims at defining their end-use properties by means of conventional standard measurements related as well as possible — and in any case, being the object of a large consensus— to end-use properties. We cite for example that octane numbers are supposed to represent the resistance of gasoline to knocking in ignition engines. 

However, this conventional method presents a certain number of limitations. In the first place, the traditional end-use property itself can be difficult to determine. Consider the cetane number for example is it a good characterization of diesel fuel with respect to its behavior in commercial diesel engines In the second place, concern for protecting the environment imposes new specifications which are often specifications linked to the composition of products very low content of certain contaminants, reduced levels of certain families of compounds, or even a specific compound as already discussed. 

Another useful property of the S matrix is that it is symmetric. This property follows from conservation of the fluxlike expression... 

An alternative method that can be used to characterize the topology of PES is the line integral technique developed by Baer [53,54], which uses properties of the non-adiabatic coupling between states to identify and locate different types of intersections. The method has been applied to study the complex PES topologies in a number of small molecules such as H3 [55,56] and C2H [57]. 

Bonaccorsi ct al. [204 defined for the first time the molecular electrostatic potential (MEP), wdicli is dearly tfie most important and most used property (Figure 2-125c. The clcctro.static potential helps to identify molecular regions that arc significant for the reactivity of compounds. Furthermore, the MEP is decisive for the formation of protein-ligand complexes. Detailed information is given in Ref [205]. 

Although its electrical conductivity is only about 60% that of copper, it is used in electrical transmission lines because of its light weight. Pure aluminum is soft and lacks strength, but it can be alloyed with small amounts of copper, magnesium, silicon, manganese, and other elements to impart a variety of useful properties. 

Silcones are important products of silicon. They may be prepared by hydrolyzing a silicon organic chloride, such as dimethyl silicon chloride. Hydrolysis and condensation of various substituted chlorosilanes can be used to produce a very great number of polymeric products, or silicones, ranging from liquids to hard, glasslike solids with many useful properties. 

Alloys with other useful properties can be obtained by using yttrium as an additive. The metal can be used as a deoxidizer for vanadium and other nonferrous metals. The metal has a low cross section for nuclear capture. 90Y, one of the isotopes of yttrium, exists in equilibrium with its parent 90Sr, a product of nuclear explosions. Yttrium has been considered for use as a nodulizer for producing nodular cast iron, in which the graphite forms compact nodules instead of the usual flakes. Such iron has increased ductility. 

Annealed rhenium is very ductile, and can be bent, coiled, or rolled. Rhenium is used as an additive to tungsten and molybdenum -based alloys to impart useful properties. 

This copolymer has useful properties from cryogenic temperatures to 180°C. Its dielectric constant is low and stable over a broad temperature and frequency range. 

It is used only as a film, and it has good resistance to abrasion and resists staining. It also has outstanding weathering resistance and maintains useful properties from — 100 to 150°C. 

A particularly useful property of the PX monomer is its enthalpy of formation. Conventional means of obtaining this value, such as through its heat of combustion, are, of course, excluded by its reactivity. An experimental attempt was made to obtain this measure of chemical reactivity with the help of ion cyclotron resonance a value of 209 17 kJ/mol (50 4 kcal/mol) was obtained (10). Unfortunately, the technique suffers from lack of resolution in addition to experimental imprecision. It is perhaps better to rely on molecular orbital calculations for the formation enthalpy. Using a semiempirical molecular orbital technique, which is tuned to give good values for heat of formation on experimentally accessible compounds, the heat of formation of /5-xylylene has been computed to be 234.8 kj/mol (56.1 kcal/mol) (11). 

Other constituents may be added to assist in the formation of uniform beads or to influence the use properties of the polymers through plasticization or cross-linking. These include lubricants, such as lauryl or cetyl alcohol and stearic acid, and cross-linking monomers such as di- or trivinylbenzene, diaHyl esters of dibasic acids, and glycol dimethacrylates. 

LOY is characterized by low spinning tension, mostiy rheological effects, Httie orientation, amorphous stmcture, low tensde strength, and high elongation. The spun filament must be drawn, usually three to six times its initial length, and heat-treated before it develops useful properties. Nearly all PET staple is spun this way. 

Tables 2—5 Hst some typical properties or ranges of properties for the more common film and sheet products. Although these values are good for comparative purposes, actual performance tests are best to determine suitabiHty for use. Properties of multiple-layer films or sheets in laminar stmctures cannot always be predicted from values for the individual polymer layers. Use conditions of stress, temperature, humidity, and light exposure all strongly influence performance. Film and sheet manufacturers can recommend product combinations or variations that may provide significant performance advantages to the user.

Poly(vinyhdene chloride) (PVDC) film has exceUent barrier properties, among the best of the common films (see Barrier polymers). It is formulated and processed into a flexible film with cling and tacky properties that make it a useful wrap for leftovers and other household uses. As a component in coatings or laminates it provides barrier properties to other film stmctures. The vinyUdene chloride is copolymerized with vinyl chloride, alkyl acrylates, and acrylonitrile to get the optimum processibUity and end use properties (see Vinylidene chloride monomer and polymers). 

Poly etrafluoroethylene is manufactured and sold in three forms granular, fine powder, and aqueous dispersion each requires a different fabrication technique. Granular resins are manufactured in a wide variety of grades to obtain a different balance between powder flows and end use properties (Pig. 1). Pine powders that are made by coagulating aqueous dispersions also are available in various grades. Differences in fine powder grades correspond to their usefulness in specific appHcations and to the ease of fabrication. Aqueous dispersions are sold in latex form and are available in different grades. A variety of formulation techniques are used to tailor these dispersions for specific appHcations. 

Heterocyclics. One of the most characteristic and useful properties of hydrazine and its derivatives is the ability to form heterocycHc compounds. Numerous pharmaceuticals, pesticides, explosives, and dyes are based on these rings. A review of the appHcation of hydrazine in the synthesis of heterocychcs is available (91). For further information in the field of heterocycHc chemistry, see the General References. 

The four key properties of inks are drying, rheology, color, and end use properties. Use properties are those considerations that determine how printed substrates function throughout all processing and usage from the time of printing throughout the useflil life of the printed product. 

Flexo and gravure inks are both known as Hquid inks because of their low viscosity. The inks for both systems have basic components in common with inks for other printing processes. Vehicles disperse and carry the pigment, and also contribute most to the end use properties. Colorants provide color. Solvents dissolve resins in the vehicle and determine drying rate. Additives modify ink properties to overcome deficiencies. 

Cellulose acetate Loeb-Sourirajan reverse osmosis membranes were introduced commercially in the 1960s. Since then, many other polymers have been made into asymmetric membranes in attempts to improve membrane properties. In the reverse osmosis area, these attempts have had limited success, the only significant example being Du Font s polyamide membrane. For gas separation and ultrafUtration, a number of membranes with useful properties have been made. However, the early work on asymmetric membranes has spawned numerous other techniques in which a microporous membrane is used as a support to carry another thin, dense separating layer. 

As engineered stmctures, nonwovens can be designed to have appearances, textures, and other aesthetic properties comparable to traditional wovens and knits, and performance and functional properties superior to traditional wovens and knits. Nonwovens are, indeed, a distinct class of fiber-based materials with the characteristics of fabric and many of its useful properties. 

Highly branched fractions of nonuniformly branched resins have low molecular weights and are easily soluble, even at room temperature, in saturated hydrocarbons. These highly branched fractions are called extractables, an excessive amount of which in an LLDPE resin can be detrimental to certain end use properties, especially in food packaging appHcations. 

---