where expertise comes together - since 1996 -

The Largest Open Access Portal of Nondestructive Testing (NDT)

Conference Proceedings, Articles, News, Exhibition, Forum, Network and more

where expertise comes together
- since 1996 -

ACS-Solutions GmbH
293 views
Technical Discussions
Jairo Humberto Guzman
Jairo Humberto Guzman
05:55 Jul-27-1998
Re: Coloring cells for MS excel thickness survey report

I send a macro example to color cells in excel
sorry These example is in spannish, but you can change the colors and value range
good luck


' Macro1 Macro
' Macro grabada 27/07/98 por Red Nacional de Datos
'
'
Proced Macro1()
Para Cada d En Rango(Rango("A1"), Rango("d1").Desviar.Fin(xlAbajo))
Número = d.Valor ' Inicializa variable.
Seleccionar Caso Número ' Evalúa Número.
Caso 1 Al 2
d.Fuente.ÍndiceColor = 5
Caso 2 Al 4
d.Fuente.ÍndiceColor = 1
Caso 5 Al 6
d.Fuente.ÍndiceColor = 2
Caso 7 Al 8
d.Fuente.ÍndiceColor = 3
Caso 9 Al 10
d.Fuente.ÍndiceColor = 4
Caso SiOtro
d.Fuente.ÍndiceColor = 6
Fin Seleccionar
Siguiente
Fin Proced



 
 Reply 
 

Product Spotlight

Echomac® Small

Available with up to eight channels of electronics to detect and evaluate thickness, flaws and eccen
...
tricity, this UT tester is housed in a convenient, smaller cabinet. This instrument can be used in conjunction with bubbler or immersion tank systems, or with a test bench or in laboratory applications. The Echomac® Small is available in the FD4, FD6 or FD6A versions.
>

Teletest Focus+

Teletest Focus+ electronics have superior capabilities than rivals on the market. Beyond the usual
...
test features, Focus+ has 24 transmit channels and 24 receive channels, with an additional on-board switching capabilities. The instrument's frequency range is 10–300 kHz.
>

ISAFE3 Intrinsically Safe Sensor System

ISAFE3 intrinsically safe sensor system of Vallen Systeme is especially targeted at the petrochemica
...
l - as well as oil and gas transportation industry. The sensor system is designed for permanent monitoring or periodic inspection tasks. Sensors are available for different AE-frequency ranges optimized for corrosion and fatigue crack detection and other applications. The ISAFE 3 sensor system consists of an AE-sensor (model ISAS3) certified according to ATEX/IEC for installation in zone 0, gas group IIC, IP68, 20 to +60 °C, and a signal isolator (model SISO3) certified for installation in zone 2. An ISAS3 sensor can be mounted in atmosphere or submerged, e.g. in water or crude oil. It is supported by mounting tools for temporary (magnets) or permanent (welded) installation. ISAFE3 supports automatic sensor coupling test and can be used with any AE signal processor supporting 28V supply at 90 mA peak, e.g. Vallen Systeme ASIP-2/A.
>

Ultrasonic Testing Immersion Tanks with Unmatched Scanning Features

TecScan’s non-destructive testing Ultrasonic Immersion Tanks & scanners are designed for high pe
...
rformance and demanding NDT testing applications. Our Scan3D™ line of High Precision Immersion Tanks are specifically designed for automated ultrasonic testing of complex composites parts used in aerospace and industrial applications.
>

Share...
We use technical and analytics cookies to ensure that we will give you the best experience of our website - More Info
Accept
top
this is debug window