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 -

257 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



    
 
 

Product Spotlight

Research Center IDEKO develops an ultrasonic train wheel inspection system for CAF

The Basque Research centre IK4-IDEKO has developed a state-of-the-art ultrasonic inspection system f
...
or the train wheel. This system secures a sound condition of train wheels and is thus a significant contribution to rail transport safety. The device was delivered to CAF recently and its use allows the manufacturer to become an approved supplier of rolling stock in Italy, as it meets the demanding homologation standards of this country. \\\\r\\\\n
>

AMIGO2

TSC Amigo2 - ACFM technology has developed a solid reputation for accurately detecting and sizing
...
surface-breaking cracks through paint and coatings. As the industry demands increased performance in speed, signal quality, and portability, it’s time for an evolution. It’s time for Amigo2.
>

Immersion systems

ScanMaster ultrasonic immersion systems are designed for high throughput, multi shift operation in a
...
n industrial or lab environment. These fully integrated systems provide various scanning configurations and incorporate conventional and phased arrays technologies to support diverse applications, such as inspection of disks, bars, shafts, billets and plates. All of ScanMaster immersion systems are built from high accuracy scanning frames allowing for scanning of complex parts and include a multi-channel ultrasonic instrument with exceptional performance. The systems are approved by all major manufacturers for C-scan inspection of jet engine forged discs. Together with a comprehensive set of software modules these flexible series of systems provide the customer with the best price performance solutions.
>

SITEX CPSERIES

Teledyne ICM’s CPSERIES has been designed with a view to revolutionizing the handling and perfor
...
mances of portable X-Ray sets. Despite having managed to halve the weight of similar portable X-Ray generators available on the market (while continuing to provide the same power output), the SITEX CPSERIES generators feature a shutter, a laser pointer, a beryllium window, an aluminum filter and two integrated diaphragms (customized sizes are available upon request). Without compromising the robustness and reliability for which ICM products are renowned, the small size and light weight of the SITEX CPSERIES will radically change the way that you perform your RT inspections. And you will see a positive impact in terms of both quality and return on investment (ROI).
>

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