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 -

EKOSCAN
EKOSCAN is a French manufacturer specialized in equipment for ultrasonic Non Destructive Testing: Probes,UT boards & Scanners tailored for your needs
294 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

IntraPhase Athena Phased Array System

The Athena Phased Array system, manufactured by WesDyne NDE Products & Technology, consists of a pha
...
sed array acquisition system and PC running IntraSpect software. A PC is used to perform acquisition, analysis and storage of the data. System hardware is capable of operating up to four data sets with any combination of phased array or conventional UT probes. NOW AVAILABLE IN 64-64 CONFIGURATION.
>

Cygnus 6+ PRO Multi-Mode Ultrasonic Thickness Gauge

The Cygnus 6+ PRO thickness gauge is the most advance gauge within the Cygnus range with key featu
...
res including: comprehensive data logging; A-scan and B-scan display; manual gain control; Bluetooth connectivity; and much more. With its unique dual display and three measuring modes (Multiple-Echo, Echo-Echo and Single-Echo), this surface thickness gauge offers maximum versatility for inspections.
>

Sci Aps Z-Series Portable Handheld Analysers

The world’s only handheld analyzer that measures carbon content in stainless (yes even L-grades),s
...
teels, and cast irons. Also accepted for low Si analysis for sulfidic corrosion analysis, and is widely used in the power industry for Cr analysis, for flow accelerated corrosion applications.
>

Customized Probes and Transducers

With a strong development department and our own piezocomposite production, we accompany you from th
...
e first product idea to serial production. Our scientists are continuously researching new methods in the field of ultrasonic measurement technology. The progress achieved enables us to offer you optimal solutions.
>

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