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 -
276 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

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.
>

HARDNESS TESTER TKM-459CE combi

TKM-459CE combi applies 2 methods of hardness control: UCI and Leeb. It provides high-accuracy tes
...
ting of metals and alloys as well as items of different sizes and configurations, their hardened layers and galvanic coatings. Device represents results in HB, HRC, HV and others. Shock-, dust- and water-proof housing with intuitive software make this gauge easy to use in all working conditions.
>

GEKKO - Portable Phased Array Testing with TFM in Real-Time

The portable phased array testing system GEKKO provides 64 parallel test channels. On creating testi
...
ng parameters the operator is assisted by the CIVA software. Due to its modular set-up the GEKKO instrument is suitable for operators of all skill levels.
>

NEW Wheel Type Phased Array Probe

DOPPLER NEW Wheel Type Phased Array Probe, more stable, new tyre makes lesser acoustic attenuation
...
, much lighter makes easier to handle, more slim size, magnetic and mechanical encoder optional etc...more
>

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