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

Semi-Automated Phased Array Immersion System for Small Composite Parts

Turn-key semi-automated system as an improved and affordable solution for inspection of small comp
...
osite parts. Includes support table, immersion tank, scanner, PA instrument, PC, Analysis software, database, wedge management and other options.
>

Ultrasonic tomograph for imaging of concrete structures А1040 MIRA

Applicable for concrete inspection allowing imaging of the internal structure of objects from conc
...
rete, reinforced concrete, different stones. The operation applies pulse-echo technique at one-side access to the object. The instrument is feasible for concrete inspection for searching conduct ducts, conduits, detection of foreign inclusions, holes, honeycombing, cracks and other concrete defects.
>

NDT.net launches mobile-friendly design

NDT.net has revamped its website providing a mobile-friendly design.The front page received a comp
...
letely new design and all other sections are now reacting responsively on mobile devices. This has been a major step to make our website more user- friendly.
>

High-performance Linear Phased Array Probes

Available to order from stock in a range of 5MHz – 7.5MHz and from 16 to 64 elements. Designed w
...
ith piezo-composite elements, Phoenix phased array probes provide high-resolution imaging to maximise sensitivity; accurate ultrasonic detection and sizing of defects in welds; and effective corrosion mapping. Housed in a rugged stainless steel case for on-site industrial NDT 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