PDA

View Full Version : filter layers in vba



test_52
6th May 2005, 08:43 pm
I am trying to find a quicker way to change the color of certain layers. I don't want to list each layer that I want changed. Is there a way to filter out certain layers according to their name? For example I have the following layers:
H-equip piped
H-duct
H-pipe
H-hatch

Is it possible to select all of the layers that contain the string "pipe"? That way I can change the color of the layers that contain "pipe" but not the others.

Any help would be great!

Jason

hendie
6th May 2005, 09:51 pm
look into the INSTR function ~ it returns a Variant specifying the position of the first occurrence of one string within another