Filter the values.

sekar_r24

New Member
Joined
Apr 18, 2020
Messages
26
Office Version
  1. 2013
Platform
  1. Windows
Hi.,

i Would like to filter the large no of rows, with data. Could some one help in the vba.
The criteria to be met is no blanks and no zeros, Thanks
Filter.xlsx
A
1Data
20
3 s.set_attribute "dynamic_attributes","lenx", "A1_WIDTH"
4 s.set_attribute "dynamic_attributes","_lenx_label", "lenx"
5 s.set_attribute "dynamic_attributes","_lenx_formulaunits", "CENTIMETERS"
60
7 s.set_attribute "dynamic_attributes","_lenx_access", "NONE"
80
90
100
110
12 s.set_attribute "dynamic_attributes","leny", "A1_DEPTH"
13 s.set_attribute "dynamic_attributes","_leny_label", "leny"
14 s.set_attribute "dynamic_attributes","_leny_formulaunits", "CENTIMETERS"
150
16 s.set_attribute "dynamic_attributes","_leny_access", "NONE"
170
180
190
200
21 s.set_attribute "dynamic_attributes","lenz", "A1_HEIGHT"
22 s.set_attribute "dynamic_attributes","_lenz_label", "lenz"
23 s.set_attribute "dynamic_attributes","_lenz_formulaunits", "CENTIMETERS"
240
25 s.set_attribute "dynamic_attributes","_lenz_access", "NONE"
260
270
280
290
30 s.set_attribute "dynamic_attributes","a", "Parameter"
31 s.set_attribute "dynamic_attributes","_a_label", "a"
320
330
340
350
360
370
380
39 s.set_attribute "dynamic_attributes","a0_item", "0"
40 s.set_attribute "dynamic_attributes","_a0_item_label", "a0_item"
410
420
430
440
450
460
470
48 s.set_attribute "dynamic_attributes","a0_label", "0"
49 s.set_attribute "dynamic_attributes","_a0_label_label", "a0_label"
500
510
520
530
540
550
560
57 s.set_attribute "dynamic_attributes","a0_type", "1"
58 s.set_attribute "dynamic_attributes","_a0_type_label", "a0_type"
59 s.set_attribute "dynamic_attributes","_a0_type_formulaunits", "STRING"
600
61 s.set_attribute "dynamic_attributes","_a0_type_access", "LIST"
62 s.set_attribute "dynamic_attributes","_a0_type_formlabel", "CABINET_TYPE"
630
64 s.set_attribute "dynamic_attributes","_a0_type_options", "MODULAR=1&SEMI-MODULAR=2"
650
66 s.set_attribute "dynamic_attributes","a1_a", "Size"
67 s.set_attribute "dynamic_attributes","_a1_a_label", "a1_a"
680
690
700
710
720
730
740
75 s.set_attribute "dynamic_attributes","a1_depth", 0
76 s.set_attribute "dynamic_attributes","_a1_depth_label", "a1_depth"
77 s.set_attribute "dynamic_attributes","_a1_depth_formulaunits", "CENTIMETERS"
780
79 s.set_attribute "dynamic_attributes","_a1_depth_access", "TEXTBOX"
80 s.set_attribute "dynamic_attributes","_a1_depth_formlabel", "CARCASS_DEPTH"
81 s.set_attribute "dynamic_attributes","_a1_depth_units", "MILLIMETERS"
820
83ast09 = 'a1_height_s + atoebaseh'
84 s.set_attribute "dynamic_attributes","a1_height", "0"
85 s.set_attribute "dynamic_attributes","_a1_height_label", "a1_height"
86 s.set_attribute "dynamic_attributes","_a1_height_formulaunits", "CENTIMETERS"
87 s.set_attribute "dynamic_attributes","_a1_height_formula", ast09
880
890
900
910
920
93 s.set_attribute "dynamic_attributes","a1_height_s", "0"
94 s.set_attribute "dynamic_attributes","_a1_height_s_label", "a1_height_s"
95 s.set_attribute "dynamic_attributes","_a1_height_s_formulaunits", "CENTIMETERS"
960
97 s.set_attribute "dynamic_attributes","_a1_height_s_access", "TEXTBOX"
98 s.set_attribute "dynamic_attributes","_a1_height_s_formlabel", "CARCASS_HEIGHT"
99 s.set_attribute "dynamic_attributes","_a1_height_s_units", "MILLIMETERS"
1000
1010
102 s.set_attribute "dynamic_attributes","a1_shutterht", "0"
103 s.set_attribute "dynamic_attributes","_a1_shutterht_label", "a1_shutterht"
104 s.set_attribute "dynamic_attributes","_a1_shutterht_formulaunits", "CENTIMETERS"
1050
106 s.set_attribute "dynamic_attributes","_a1_shutterht_access", "TEXTBOX"
107 s.set_attribute "dynamic_attributes","_a1_shutterht_formlabel", "SHUTTER_HEIGHT"
108 s.set_attribute "dynamic_attributes","_a1_shutterht_units", "MILLIMETERS"
1090
1100
111 s.set_attribute "dynamic_attributes","a1_shutterht_s", "0"
112 s.set_attribute "dynamic_attributes","_a1_shutterht_s_label", "a1_shutterht_s"
113 s.set_attribute "dynamic_attributes","_a1_shutterht_s_formulaunits", "CENTIMETERS"
1140
1150
1160
117 s.set_attribute "dynamic_attributes","_a1_shutterht_s_units", "MILLIMETERS"
1180
1190
120 s.set_attribute "dynamic_attributes","a1_width", "0"
121 s.set_attribute "dynamic_attributes","_a1_width_label", "a1_width"
122 s.set_attribute "dynamic_attributes","_a1_width_formulaunits", "CENTIMETERS"
1230
1240
1250
126 s.set_attribute "dynamic_attributes","_a1_width_units", "MILLIMETERS"
1270
1280
129 s.set_attribute "dynamic_attributes","a1_width_s", "0"
130 s.set_attribute "dynamic_attributes","_a1_width_s_label", "a1_width_s"
131 s.set_attribute "dynamic_attributes","_a1_width_s_formulaunits", "CENTIMETERS"
1320
133 s.set_attribute "dynamic_attributes","_a1_width_s_access", "TEXTBOX"
134 s.set_attribute "dynamic_attributes","_a1_width_s_formlabel", "CARCASS_WIDTH (600..900)"
135 s.set_attribute "dynamic_attributes","_a1_width_s_units", "MILLIMETERS"
1360
1370
138 s.set_attribute "dynamic_attributes","a2_a", "Thickness"
139 s.set_attribute "dynamic_attributes","_a2_a_label", "a2_a"
1400
1410
1420
1430
1440
1450
1460
147 s.set_attribute "dynamic_attributes","a2_bacthickness", 0.8/2.54
148 s.set_attribute "dynamic_attributes","_a2_bacthickness_label", "a2_bacthickness"
149 s.set_attribute "dynamic_attributes","_a2_bacthickness_formulaunits", "CENTIMETERS"
1500
1510
1520
153 s.set_attribute "dynamic_attributes","_a2_bacthickness_units", "CENTIMETERS"
1540
1550
156 s.set_attribute "dynamic_attributes","a2_carthickness", 1.8/2.54
157 s.set_attribute "dynamic_attributes","_a2_carthickness_label", "a2_carthickness"
158 s.set_attribute "dynamic_attributes","_a2_carthickness_formulaunits", "CENTIMETERS"
1590
1600
1610
162 s.set_attribute "dynamic_attributes","_a2_carthickness_units", "CENTIMETERS"
1630
1640
165 s.set_attribute "dynamic_attributes","a2_doothickness", 1.8/2.54
166 s.set_attribute "dynamic_attributes","_a2_doothickness_label", "a2_doothickness"
167 s.set_attribute "dynamic_attributes","_a2_doothickness_formulaunits", "CENTIMETERS"
1680
1690
1700
171 s.set_attribute "dynamic_attributes","_a2_doothickness_units", "CENTIMETERS"
1720
1730
174 s.set_attribute "dynamic_attributes","a2_zrevbottom", 0/2.54
175 s.set_attribute "dynamic_attributes","_a2_zrevbottom_label", "a2_zrevbottom"
176 s.set_attribute "dynamic_attributes","_a2_zrevbottom_formulaunits", "CENTIMETERS"
1770
1780
1790
180 s.set_attribute "dynamic_attributes","_a2_zrevbottom_units", "CENTIMETERS"
1810
1820
183 s.set_attribute "dynamic_attributes","a2_zrevedge", 0.1/2.54
184 s.set_attribute "dynamic_attributes","_a2_zrevedge_label", "a2_zrevedge"
185 s.set_attribute "dynamic_attributes","_a2_zrevedge_formulaunits", "CENTIMETERS"
1860
1870
1880
189 s.set_attribute "dynamic_attributes","_a2_zrevedge_units", "CENTIMETERS"
1900
1910
192 s.set_attribute "dynamic_attributes","a2_zrevtop", 0.5/2.54
193 s.set_attribute "dynamic_attributes","_a2_zrevtop_label", "a2_zrevtop"
194 s.set_attribute "dynamic_attributes","_a2_zrevtop_formulaunits", "CENTIMETERS"
1950
1960
1970
198 s.set_attribute "dynamic_attributes","_a2_zrevtop_units", "CENTIMETERS"
1990
2000
201 s.set_attribute "dynamic_attributes","a3", "Style"
202 s.set_attribute "dynamic_attributes","_a3_label", "a3"
2030
2040
2050
2060
2070
2080
2090
210 s.set_attribute "dynamic_attributes","a3_amaterialdoor_dorl", "3"
211 s.set_attribute "dynamic_attributes","_a3_amaterialdoor_dorl_label", "a3_amaterialdoor_dorl"
212 s.set_attribute "dynamic_attributes","_a3_amaterialdoor_dorl_formulaunits", "STRING"
2130
214 s.set_attribute "dynamic_attributes","_a3_amaterialdoor_dorl_access", "LIST"
215 s.set_attribute "dynamic_attributes","_a3_amaterialdoor_dorl_formlabel", "FINISH_DOOR_EXPOSED"
216 s.set_attribute "dynamic_attributes","_a3_amaterialdoor_dorl_units", "STRING"
217 s.set_attribute "dynamic_attributes","_a3_amaterialdoor_dorl_options", "DARK-DARK=1&LIGHT-LIGHT=2&DARK-LIGHT=3"
2180
219 s.set_attribute "dynamic_attributes","a3_amaterial_carcase_inner", "White laminate"
220 s.set_attribute "dynamic_attributes","_a3_amaterial_carcase_inner_label", "a3_amaterial_carcase_inner"
2210
2220
2230
2240
2250
2260
2270
228 s.set_attribute "dynamic_attributes","a3_amaterial_carcase_outer_d", "Berry Bunch"
229 s.set_attribute "dynamic_attributes","_a3_amaterial_carcase_outer_d_label", "a3_amaterial_carcase_outer_d"
2300
2310
2320
2330
2340
2350
2360
237 s.set_attribute "dynamic_attributes","a3_amaterial_carcase_outer_l", "Champange"
238 s.set_attribute "dynamic_attributes","_a3_amaterial_carcase_outer_l_label", "a3_amaterial_carcase_outer_l"
2390
2400
2410
2420
2430
2440
2450
246 s.set_attribute "dynamic_attributes","a3_amaterial_dorl", "LIGHT"
247 s.set_attribute "dynamic_attributes","_a3_amaterial_dorl_label", "a3_amaterial_dorl"
2480
2490
250 s.set_attribute "dynamic_attributes","_a3_amaterial_dorl_access", "LIST"
251 s.set_attribute "dynamic_attributes","_a3_amaterial_dorl_formlabel", "CARCASS_EXPOSED"
2520
253 s.set_attribute "dynamic_attributes","_a3_amaterial_dorl_options", "DARK=DARK&LIGHT=LIGHT"
254ast28 = 'if(A3_aMATERIAL_DorL="DARK",A3_aMATERIAL_CARCASE_Outer_D,A3_aMATERIAL_CARCASE_Outer_L)'
255 s.set_attribute "dynamic_attributes","a3_amaterial_dorl1", "0"
256 s.set_attribute "dynamic_attributes","_a3_amaterial_dorl1_label", "a3_amaterial_dorl1"
257 s.set_attribute "dynamic_attributes","_a3_amaterial_dorl1_formulaunits", "STRING"
258 s.set_attribute "dynamic_attributes","_a3_amaterial_dorl1_formula", ast28
2590
2600
261 s.set_attribute "dynamic_attributes","_a3_amaterial_dorl1_units", "STRING"
2620
2630
264 s.set_attribute "dynamic_attributes","a3_amaterial_exposed", "4"
265 s.set_attribute "dynamic_attributes","_a3_amaterial_exposed_label", "a3_amaterial_exposed"
266 s.set_attribute "dynamic_attributes","_a3_amaterial_exposed_formulaunits", "STRING"
2670
268 s.set_attribute "dynamic_attributes","_a3_amaterial_exposed_access", "LIST"
269 s.set_attribute "dynamic_attributes","_a3_amaterial_exposed_formlabel", "CARCASS_EXPOSED_SIDE"
270 s.set_attribute "dynamic_attributes","_a3_amaterial_exposed_units", "STRING"
271 s.set_attribute "dynamic_attributes","_a3_amaterial_exposed_options", "No=1&Right=2&Left=3&Both=4&Inner=5"
2720
273 s.set_attribute "dynamic_attributes","a3_aqtyshelf", "1"
274 s.set_attribute "dynamic_attributes","_a3_aqtyshelf_label", "a3_aqtyshelf"
275 s.set_attribute "dynamic_attributes","_a3_aqtyshelf_formulaunits", "STRING"
2760
2770
2780
279 s.set_attribute "dynamic_attributes","_a3_aqtyshelf_units", "STRING"
2800
281ast31 = 'CHOOSE(A3_BackStructure,A3_BackInset_S,0,-A2_BacThickness,0)'
282 s.set_attribute "dynamic_attributes","a3_backinset", "=CHOOSE(A3_BackStructure,A3_BackInset_S,0,-A2_BacThickness,0)"
283 s.set_attribute "dynamic_attributes","_a3_backinset_label", "a3_backinset"
284 s.set_attribute "dynamic_attributes","_a3_backinset_formulaunits", "CENTIMETERS"
285 s.set_attribute "dynamic_attributes","_a3_backinset_formula", ast31
2860
2870
288 s.set_attribute "dynamic_attributes","_a3_backinset_units", "CENTIMETERS"
2890
2900
291 s.set_attribute "dynamic_attributes","a3_backinset_s", 0.4/2.54
292 s.set_attribute "dynamic_attributes","_a3_backinset_s_label", "a3_backinset_s"
293 s.set_attribute "dynamic_attributes","_a3_backinset_s_formulaunits", "CENTIMETERS"
2940
2950
2960
297 s.set_attribute "dynamic_attributes","_a3_backinset_s_units", "CENTIMETERS"
2980
299ast33 = 'CHOOSE(A3_BackStructure,A3_BackPanelOffset_S,A3_BackPanelOffset_S,A2_CarThickness,0)'
300 s.set_attribute "dynamic_attributes","a3_backpaneloffset", "=CHOOSE(A3_BackStructure,A3_BackPanelOffset_S,A3_BackPanelOffset_S,A2_CarThickness,0)"
301 s.set_attribute "dynamic_attributes","_a3_backpaneloffset_label", "a3_backpaneloffset"
302 s.set_attribute "dynamic_attributes","_a3_backpaneloffset_formulaunits", "CENTIMETERS"
303 s.set_attribute "dynamic_attributes","_a3_backpaneloffset_formula", ast33
3040
3050
306 s.set_attribute "dynamic_attributes","_a3_backpaneloffset_units", "CENTIMETERS"
3070
3080
309 s.set_attribute "dynamic_attributes","a3_backpaneloffset_s", "1/2.54"
310 s.set_attribute "dynamic_attributes","_a3_backpaneloffset_s_label", "a3_backpaneloffset_s"
311 s.set_attribute "dynamic_attributes","_a3_backpaneloffset_s_formulaunits", "CENTIMETERS"
3120
3130
3140
315 s.set_attribute "dynamic_attributes","_a3_backpaneloffset_s_units", "CENTIMETERS"
3160
3170
318 s.set_attribute "dynamic_attributes","a3_backstructure", "1"
319 s.set_attribute "dynamic_attributes","_a3_backstructure_label", "a3_backstructure"
320 s.set_attribute "dynamic_attributes","_a3_backstructure_formulaunits", "STRING"
3210
322 s.set_attribute "dynamic_attributes","_a3_backstructure_access", "LIST"
323 s.set_attribute "dynamic_attributes","_a3_backstructure_formlabel", "Back Structure"
324 s.set_attribute "dynamic_attributes","_a3_backstructure_units", "STRING"
325 s.set_attribute "dynamic_attributes","_a3_backstructure_options", "Grooved=1&rebated=2&Fitted onto=3&No Back Panel=4"
3260
327 s.set_attribute "dynamic_attributes","a3_cfrontclear", 3.8/2.54
328 s.set_attribute "dynamic_attributes","_a3_cfrontclear_label", "a3_cfrontclear"
329 s.set_attribute "dynamic_attributes","_a3_cfrontclear_formulaunits", "CENTIMETERS"
3300
3310
3320
333 s.set_attribute "dynamic_attributes","_a3_cfrontclear_units", "CENTIMETERS"
3340
3350
336 s.set_attribute "dynamic_attributes","a3_chopstickangle", "2"
337 s.set_attribute "dynamic_attributes","_a3_chopstickangle_label", "a3_chopstickangle"
338 s.set_attribute "dynamic_attributes","_a3_chopstickangle_formulaunits", "STRING"
3390
340 s.set_attribute "dynamic_attributes","_a3_chopstickangle_access", "LIST"
341 s.set_attribute "dynamic_attributes","_a3_chopstickangle_formlabel", "Position of Handle - Horizontal or vertical"
342 s.set_attribute "dynamic_attributes","_a3_chopstickangle_units", "STRING"
343 s.set_attribute "dynamic_attributes","_a3_chopstickangle_options", "Horizontal=1&Vertical=2"
3440
345 s.set_attribute "dynamic_attributes","a3_cncpanotype", "1"
346 s.set_attribute "dynamic_attributes","_a3_cncpanotype_label", "a3_cncpanotype"
347 s.set_attribute "dynamic_attributes","_a3_cncpanotype_formulaunits", "STRING"
3480
3490
3500
351 s.set_attribute "dynamic_attributes","_a3_cncpanotype_units", "STRING"
3520
3530
354 s.set_attribute "dynamic_attributes","a3_edgthiofedgdoor", 0.2/2.54
355 s.set_attribute "dynamic_attributes","_a3_edgthiofedgdoor_label", "a3_edgthiofedgdoor"
356 s.set_attribute "dynamic_attributes","_a3_edgthiofedgdoor_formulaunits", "CENTIMETERS"
3570
3580
3590
360 s.set_attribute "dynamic_attributes","_a3_edgthiofedgdoor_units", "CENTIMETERS"
3610
3620
363 s.set_attribute "dynamic_attributes","a3_froraiangle", "180"
364 s.set_attribute "dynamic_attributes","_a3_froraiangle_label", "a3_froraiangle"
365 s.set_attribute "dynamic_attributes","_a3_froraiangle_formulaunits", "STRING"
3660
3670
3680
369 s.set_attribute "dynamic_attributes","_a3_froraiangle_units", "STRING"
3700
3710
372 s.set_attribute "dynamic_attributes","a3_froraiwidth", 10/2.54
373 s.set_attribute "dynamic_attributes","_a3_froraiwidth_label", "a3_froraiwidth"
374 s.set_attribute "dynamic_attributes","_a3_froraiwidth_formulaunits", "CENTIMETERS"
3750
3760
3770
378 s.set_attribute "dynamic_attributes","_a3_froraiwidth_units", "CENTIMETERS"
3790
3800
381 s.set_attribute "dynamic_attributes","a3_graindirection", "2"
382 s.set_attribute "dynamic_attributes","_a3_graindirection_label", "a3_graindirection"
383 s.set_attribute "dynamic_attributes","_a3_graindirection_formulaunits", "STRING"
3840
385 s.set_attribute "dynamic_attributes","_a3_graindirection_access", "LIST"
386 s.set_attribute "dynamic_attributes","_a3_graindirection_formlabel", "Grain_Direction"
387 s.set_attribute "dynamic_attributes","_a3_graindirection_units", "STRING"
388 s.set_attribute "dynamic_attributes","_a3_graindirection_options", "Horizontal=1&Vertical=2"
3890
390 s.set_attribute "dynamic_attributes","a3_heiofgappull", 2.4/2.54
391 s.set_attribute "dynamic_attributes","_a3_heiofgappull_label", "a3_heiofgappull"
392 s.set_attribute "dynamic_attributes","_a3_heiofgappull_formulaunits", "CENTIMETERS"
3930
3940
3950
396 s.set_attribute "dynamic_attributes","_a3_heiofgappull_units", "CENTIMETERS"
3970
3980
399 s.set_attribute "dynamic_attributes","a3_heioflonpull", 3.5/2.54
400 s.set_attribute "dynamic_attributes","_a3_heioflonpull_label", "a3_heioflonpull"
401 s.set_attribute "dynamic_attributes","_a3_heioflonpull_formulaunits", "CENTIMETERS"
4020
4030
4040
405 s.set_attribute "dynamic_attributes","_a3_heioflonpull_units", "CENTIMETERS"
4060
407
408 s.set_attribute "dynamic_attributes","A3_heiofaledPull", 0.3/2.54
409 s.set_attribute "dynamic_attributes","_A3_heiofaledPull_label", "A3_heiofaledPull"
410 s.set_attribute "dynamic_attributes","_A3_heiofaledPull_formulaunits", "CENTIMETERS"
411
4120
4130
414 s.set_attribute "dynamic_attributes","_A3_heiofaledPull_units", "CENTIMETERS"
4150
4160
417 s.set_attribute "dynamic_attributes","a3_heiofstdpull", 20/2.54
418 s.set_attribute "dynamic_attributes","_a3_heiofstdpull_label", "a3_heiofstdpull"
419 s.set_attribute "dynamic_attributes","_a3_heiofstdpull_formulaunits", "CENTIMETERS"
4200
4210
4220
423 s.set_attribute "dynamic_attributes","_a3_heiofstdpull_units", "CENTIMETERS"
4240
4250
426 s.set_attribute "dynamic_attributes","a3_hintype", "33"
427 s.set_attribute "dynamic_attributes","_a3_hintype_label", "a3_hintype"
428 s.set_attribute "dynamic_attributes","_a3_hintype_formulaunits", "STRING"
4290
4300
4310
432 s.set_attribute "dynamic_attributes","_a3_hintype_units", "STRING"
4330
4340
435 s.set_attribute "dynamic_attributes","a3_pullplacex", 5/2.54
436 s.set_attribute "dynamic_attributes","_a3_pullplacex_label", "a3_pullplacex"
437 s.set_attribute "dynamic_attributes","_a3_pullplacex_formulaunits", "CENTIMETERS"
4380
4390
4400
441 s.set_attribute "dynamic_attributes","_a3_pullplacex_units", "CENTIMETERS"
4420
4430
444 s.set_attribute "dynamic_attributes","a3_pullplacey", 8/2.54
445 s.set_attribute "dynamic_attributes","_a3_pullplacey_label", "a3_pullplacey"
446 s.set_attribute "dynamic_attributes","_a3_pullplacey_formulaunits", "CENTIMETERS"
4470
4480
4490
450 s.set_attribute "dynamic_attributes","_a3_pullplacey_units", "CENTIMETERS"
4510
4520
453 s.set_attribute "dynamic_attributes","a3_raifullonoff", "1"
454 s.set_attribute "dynamic_attributes","_a3_raifullonoff_label", "a3_raifullonoff"
455 s.set_attribute "dynamic_attributes","_a3_raifullonoff_formulaunits", "STRING"
4560
457 s.set_attribute "dynamic_attributes","_a3_raifullonoff_access", "LIST"
458 s.set_attribute "dynamic_attributes","_a3_raifullonoff_formlabel", "Rail Full Depth"
459 s.set_attribute "dynamic_attributes","_a3_raifullonoff_units", "STRING"
460 s.set_attribute "dynamic_attributes","_a3_raifullonoff_options", "Off=1&On=2"
4610
462 s.set_attribute "dynamic_attributes","a3_topedgeangleingappull", 1.6/2.54
463 s.set_attribute "dynamic_attributes","_a3_topedgeangleingappull_label", "a3_topedgeangleingappull"
464 s.set_attribute "dynamic_attributes","_a3_topedgeangleingappull_formulaunits", "CENTIMETERS"
4650
4660
4670
468 s.set_attribute "dynamic_attributes","_a3_topedgeangleingappull_units", "CENTIMETERS"
4690
4700
471 s.set_attribute "dynamic_attributes","a4", "Customise"
472 s.set_attribute "dynamic_attributes","_a4_label", "a4"
4730
4740
4750
4760
4770
4780
479ast65 = 'IF(aDoorType=176,0,A5_DOORPULL_S)'
480 s.set_attribute "dynamic_attributes","a5_doorpull", "=IF(aDoorType=176,0,A5_DOORPULL_S)"
481 s.set_attribute "dynamic_attributes","_a5_doorpull_label", "a5_doorpull"
482 s.set_attribute "dynamic_attributes","_a5_doorpull_formulaunits", "CENTIMETERS"
483 s.set_attribute "dynamic_attributes","_a5_doorpull_formula", ast65
4840
4850
486 s.set_attribute "dynamic_attributes","_a5_doorpull_units", "CENTIMETERS"
4870
4880
489 s.set_attribute "dynamic_attributes","a5_doorpull_s", "31"
490 s.set_attribute "dynamic_attributes","_a5_doorpull_s_label", "a5_doorpull_s"
491 s.set_attribute "dynamic_attributes","_a5_doorpull_s_formulaunits", "STRING"
4920
4930
4940
495 s.set_attribute "dynamic_attributes","_a5_doorpull_s_units", "STRING"
4960
4970
498 s.set_attribute "dynamic_attributes","a5_doorpull_sel", "31"
499 s.set_attribute "dynamic_attributes","_a5_doorpull_sel_label", "a5_doorpull_sel"
500 s.set_attribute "dynamic_attributes","_a5_doorpull_sel_formulaunits", "STRING"
5010
502 s.set_attribute "dynamic_attributes","_a5_doorpull_sel_access", "LIST"
503 s.set_attribute "dynamic_attributes","_a5_doorpull_sel_formlabel", "HANDLE NO"
504 s.set_attribute "dynamic_attributes","_a5_doorpull_sel_units", "STRING"
505 s.set_attribute "dynamic_attributes","_a5_doorpull_sel_options", "PULL=31&FINGERGROOVE=27&GPROFILE_02=29&PROFILEEDGE=30"
5060
507 s.set_attribute "dynamic_attributes","a5_jhandletype", "J1"
508 s.set_attribute "dynamic_attributes","_a5_jhandletype_label", "a5_jhandletype"
509 s.set_attribute "dynamic_attributes","_a5_jhandletype_formulaunits", "STRING"
5100
5110
5120
513 s.set_attribute "dynamic_attributes","_a5_jhandletype_units", "STRING"
5140
5150
516 s.set_attribute "dynamic_attributes","a6_addon", "0"
517 s.set_attribute "dynamic_attributes","_a6_addon_label", "a6_addon"
518 s.set_attribute "dynamic_attributes","_a6_addon_formulaunits", "STRING"
5190
5200
5210
522 s.set_attribute "dynamic_attributes","_a6_addon_units", "STRING"
5230
5240
525 s.set_attribute "dynamic_attributes","adoorhand", "2"
526 s.set_attribute "dynamic_attributes","_adoorhand_label", "adoorhand"
527 s.set_attribute "dynamic_attributes","_adoorhand_formulaunits", "STRING"
5280
5290
5300
531 s.set_attribute "dynamic_attributes","_adoorhand_units", "STRING"
5320
5330
534 s.set_attribute "dynamic_attributes","adoortype", "176"
535 s.set_attribute "dynamic_attributes","_adoortype_label", "adoortype"
536 s.set_attribute "dynamic_attributes","_adoortype_formulaunits", "STRING"
5370
538 s.set_attribute "dynamic_attributes","_adoortype_access", "LIST"
539 s.set_attribute "dynamic_attributes","_adoortype_formlabel", "DOOR TYPE"
540 s.set_attribute "dynamic_attributes","_adoortype_units", "STRING"
541 s.set_attribute "dynamic_attributes","_adoortype_options", "NORMAL=175&PROFILE=176&PFINGER GROOVE=177"
542ast72 = 'A3_PullPlaceY'
543 s.set_attribute "dynamic_attributes","apullinseth", "=A3_PullPlaceY"
544 s.set_attribute "dynamic_attributes","_apullinseth_label", "apullinseth"
545 s.set_attribute "dynamic_attributes","_apullinseth_formulaunits", "CENTIMETERS"
546 s.set_attribute "dynamic_attributes","_apullinseth_formula", ast72
5470
5480
549 s.set_attribute "dynamic_attributes","_apullinseth_units", "CENTIMETERS"
5500
5510
552 s.set_attribute "dynamic_attributes","apullinsetw", 5/2.54
553 s.set_attribute "dynamic_attributes","_apullinsetw_label", "apullinsetw"
554 s.set_attribute "dynamic_attributes","_apullinsetw_formulaunits", "CENTIMETERS"
5550
5560
5570
558 s.set_attribute "dynamic_attributes","_apullinsetw_units", "CENTIMETERS"
5590
5600
561 s.set_attribute "dynamic_attributes","atoebaseh", 10/2.54
562 s.set_attribute "dynamic_attributes","_atoebaseh_label", "atoebaseh"
563 s.set_attribute "dynamic_attributes","_atoebaseh_formulaunits", "CENTIMETERS"
5640
5650
5660
567 s.set_attribute "dynamic_attributes","_atoebaseh_units", "CENTIMETERS"
5680
5690
570 s.set_attribute "dynamic_attributes","c", "Material_Code"
571 s.set_attribute "dynamic_attributes","_c_label", "c"
5720
5730
5740
5750
5760
5770
5780
579 s.set_attribute "dynamic_attributes","c2_bandedge_carcase", "1"
580 s.set_attribute "dynamic_attributes","_c2_bandedge_carcase_label", "c2_bandedge_carcase"
581 s.set_attribute "dynamic_attributes","_c2_bandedge_carcase_formulaunits", "STRING"
5820
583 s.set_attribute "dynamic_attributes","_c2_bandedge_carcase_access", "LIST"
584 s.set_attribute "dynamic_attributes","_c2_bandedge_carcase_formlabel", "Carcass Edge Band"
585 s.set_attribute "dynamic_attributes","_c2_bandedge_carcase_units", "STRING"
586 s.set_attribute "dynamic_attributes","_c2_bandedge_carcase_options", "External=1&Internal=2"
5870
588 s.set_attribute "dynamic_attributes","c2_material_carcase", "Laminate"
589 s.set_attribute "dynamic_attributes","_c2_material_carcase_label", "c2_material_carcase"
5900
5910
592 s.set_attribute "dynamic_attributes","_c2_material_carcase_access", "LIST"
593 s.set_attribute "dynamic_attributes","_c2_material_carcase_formlabel", "OUTER CARCASS FINISH - TYPE"
5940
595 s.set_attribute "dynamic_attributes","_c2_material_carcase_options", "Lam_IDLIST01=Laminate&Paint_IDLIST02=PU-Lacquer_Paint&VENEER_IDLIST03=Veneer&SW_IDLIST04=Solidwood"
5960
597 s.set_attribute "dynamic_attributes","c2_material_carcase_bandplane", "1"
598 s.set_attribute "dynamic_attributes","_c2_material_carcase_bandplane_label", "c2_material_carcase_bandplane"
599 s.set_attribute "dynamic_attributes","_c2_material_carcase_bandplane_formulaunits", "STRING"
6000
601 s.set_attribute "dynamic_attributes","_c2_material_carcase_bandplane_access", "LIST"
602 s.set_attribute "dynamic_attributes","_c2_material_carcase_bandplane_formlabel", "CARCASS FINISH"
603 s.set_attribute "dynamic_attributes","_c2_material_carcase_bandplane_units", "STRING"
604 s.set_attribute "dynamic_attributes","_c2_material_carcase_bandplane_options", "2M are Same=1&2M are Different=2"
6050
606 s.set_attribute "dynamic_attributes","c2_material_carcase_code", "MS 071 T - Slate"
607 s.set_attribute "dynamic_attributes","_c2_material_carcase_code_label", "c2_material_carcase_code"
6080
6090
6100
6110
6120
6130
6140
615 s.set_attribute "dynamic_attributes","c2_material_carcase_face_edge", "N/A"
616 s.set_attribute "dynamic_attributes","_c2_material_carcase_face_edge_label", "c2_material_carcase_face_edge"
6170
6180
6190
6200
6210
6220
6230
624 s.set_attribute "dynamic_attributes","c2_material_carcase_idmat", "MAT194"
625 s.set_attribute "dynamic_attributes","_c2_material_carcase_idmat_label", "c2_material_carcase_idmat"
6260
6270
6280
6290
6300
6310
6320
633 s.set_attribute "dynamic_attributes","c2_material_carcase_mint", "Laminate"
634 s.set_attribute "dynamic_attributes","_c2_material_carcase_mint_label", "c2_material_carcase_mint"
6350
6360
637 s.set_attribute "dynamic_attributes","_c2_material_carcase_mint_access", "LIST"
638 s.set_attribute "dynamic_attributes","_c2_material_carcase_mint_formlabel", "INNER CARCASS FINISH - TYPE"
6390
640 s.set_attribute "dynamic_attributes","_c2_material_carcase_mint_options", "Lam_IDLIST01=Laminate&Paint_IDLIST02=PU-Lacquer_Paint&VENEER_IDLIST03=Veneer&SW_IDLIST04=Solidwood"
6410
642 s.set_attribute "dynamic_attributes","c2_material_carcase_mint_idmat", "MAT194"
643 s.set_attribute "dynamic_attributes","_c2_material_carcase_mint_idmat_label", "c2_material_carcase_mint_idmat"
6440
6450
6460
6470
6480
6490
6500
651 s.set_attribute "dynamic_attributes","c2_material_carcase_use01_idbanding", "132P"
652 s.set_attribute "dynamic_attributes","_c2_material_carcase_use01_idbanding_label", "c2_material_carcase_use01_idbanding"
6530
6540
655 s.set_attribute "dynamic_attributes","_c2_material_carcase_use01_idbanding_access", "TEXTBOX"
656 s.set_attribute "dynamic_attributes","_c2_material_carcase_use01_idbanding_formlabel", "EDGEBAND - EB_01(DARK)"
6570
6580
6590
660 s.set_attribute "dynamic_attributes","c2_material_carcase_use02_idbanding", "212P"
661 s.set_attribute "dynamic_attributes","_c2_material_carcase_use02_idbanding_label", "c2_material_carcase_use02_idbanding"
6620
6630
664 s.set_attribute "dynamic_attributes","_c2_material_carcase_use02_idbanding_access", "TEXTBOX"
665 s.set_attribute "dynamic_attributes","_c2_material_carcase_use02_idbanding_formlabel", "EDGEBAND - EB_01(LIGHT)"
6660
6670
6680
669 s.set_attribute "dynamic_attributes","c2_material_carcase_use03_banding", "414P"
670 s.set_attribute "dynamic_attributes","_c2_material_carcase_use03_banding_label", "c2_material_carcase_use03_banding"
6710
6720
673 s.set_attribute "dynamic_attributes","_c2_material_carcase_use03_banding_access", "TEXTBOX"
674 s.set_attribute "dynamic_attributes","_c2_material_carcase_use03_banding_formlabel", "EDGEBAND - EB_01(WHITE)"
6750
6760
6770
678 s.set_attribute "dynamic_attributes","c2_material_carcase_use_cat_banding", "PVC"
679 s.set_attribute "dynamic_attributes","_c2_material_carcase_use_cat_banding_label", "c2_material_carcase_use_cat_banding"
6800
6810
682 s.set_attribute "dynamic_attributes","_c2_material_carcase_use_cat_banding_access", "LIST"
683 s.set_attribute "dynamic_attributes","_c2_material_carcase_use_cat_banding_formlabel", "CARCASS EDGE BAND"
6840
685 s.set_attribute "dynamic_attributes","_c2_material_carcase_use_cat_banding_options", "PVC-CATE07=PVC&ACRYLIC - CATE04=ACRYLIC&VENEER-CATE03=Veneer&PAINT-CATE02=PAINT"
6860
687 s.set_attribute "dynamic_attributes","c2_material_carcase_use_cat_core", "Plywood"
688 s.set_attribute "dynamic_attributes","_c2_material_carcase_use_cat_core_label", "c2_material_carcase_use_cat_core"
6890
6900
691 s.set_attribute "dynamic_attributes","_c2_material_carcase_use_cat_core_access", "LIST"
692 s.set_attribute "dynamic_attributes","_c2_material_carcase_use_cat_core_formlabel", "CARCASS CORE"
6930
694 s.set_attribute "dynamic_attributes","_c2_material_carcase_use_cat_core_options", "Plywood-CATC04=Plywood&ParticleBoard - CATC02=PARTICLEBOARD&HDHMR-CATC01=HDHMR"
6950
696 s.set_attribute "dynamic_attributes","c2_material_carcase_use_idcore", "Plywood-BWR-CORE05"
697 s.set_attribute "dynamic_attributes","_c2_material_carcase_use_idcore_label", "c2_material_carcase_use_idcore"
6980
6990
700 s.set_attribute "dynamic_attributes","_c2_material_carcase_use_idcore_access", "LIST"
701 s.set_attribute "dynamic_attributes","_c2_material_carcase_use_idcore_formlabel", "CARCASS CORE"
7020
703 s.set_attribute "dynamic_attributes","_c2_material_carcase_use_idcore_options", "Plywood-BWR-CORE05=Plywood-BWR&Plywood-Commercial-CORE21=Plywood-Commercial"
7040
705 s.set_attribute "dynamic_attributes","c2_material_door", "Laminate"
706 s.set_attribute "dynamic_attributes","_c2_material_door_label", "c2_material_door"
7070
7080
709 s.set_attribute "dynamic_attributes","_c2_material_door_access", "LIST"
710 s.set_attribute "dynamic_attributes","_c2_material_door_formlabel", "DOOR FINISH - TYPE"
7110
712 s.set_attribute "dynamic_attributes","_c2_material_door_options", "Lam_IDLIST01=Laminate&Paint_IDLIST02=PU-Lacquer_Paint&VENEER_IDLIST03=Veneer&SW_IDLIST04=Solidwood"
7130
714 s.set_attribute "dynamic_attributes","c2_material_door_bandplane", "1M"
715 s.set_attribute "dynamic_attributes","_c2_material_door_bandplane_label", "c2_material_door_bandplane"
7160
7170
718 s.set_attribute "dynamic_attributes","_c2_material_door_bandplane_access", "LIST"
719 s.set_attribute "dynamic_attributes","_c2_material_door_bandplane_formlabel", "DOOR FINISH"
7200
721 s.set_attribute "dynamic_attributes","_c2_material_door_bandplane_options", "2M are Same=1M&2M are Different=2M"
7220
723 s.set_attribute "dynamic_attributes","c2_material_door_code", "MS SL 916"
724 s.set_attribute "dynamic_attributes","_c2_material_door_code_label", "c2_material_door_code"
7250
7260
7270
7280
7290
7300
7310
732 s.set_attribute "dynamic_attributes","c2_material_door_idmat", "MAT158"
733 s.set_attribute "dynamic_attributes","_c2_material_door_idmat_label", "c2_material_door_idmat"
7340
7350
7360
7370
7380
7390
7400
741 s.set_attribute "dynamic_attributes","c2_material_door_mint", "Laminate"
742 s.set_attribute "dynamic_attributes","_c2_material_door_mint_label", "c2_material_door_mint"
7430
7440
745 s.set_attribute "dynamic_attributes","_c2_material_door_mint_access", "LIST"
746 s.set_attribute "dynamic_attributes","_c2_material_door_mint_formlabel", "INNER CARCASS FINISH - TYPE"
7470
748 s.set_attribute "dynamic_attributes","_c2_material_door_mint_options", "Lam_IDLIST01=Laminate&Paint_IDLIST02=PU-Lacquer_Paint&VENEER_IDLIST03=Veneer&SW_IDLIST04=Solidwood"
7490
750 s.set_attribute "dynamic_attributes","c2_material_door_mint_code", "MS SL 916"
751 s.set_attribute "dynamic_attributes","_c2_material_door_mint_code_label", "c2_material_door_mint_code"
7520
7530
7540
7550
7560
7570
7580
759 s.set_attribute "dynamic_attributes","c2_material_door_mint_idmat", "MAT158"
760 s.set_attribute "dynamic_attributes","_c2_material_door_mint_idmat_label", "c2_material_door_mint_idmat"
7610
7620
7630
7640
7650
7660
7670
768 s.set_attribute "dynamic_attributes","c2_material_door_use_cat_banding", "PVC"
769 s.set_attribute "dynamic_attributes","_c2_material_door_use_cat_banding_label", "c2_material_door_use_cat_banding"
7700
7710
772 s.set_attribute "dynamic_attributes","_c2_material_door_use_cat_banding_access", "LIST"
773 s.set_attribute "dynamic_attributes","_c2_material_door_use_cat_banding_formlabel", "DOOR EDGE BAND"
7740
775 s.set_attribute "dynamic_attributes","_c2_material_door_use_cat_banding_options", "PVC-CATE07=PVC&ACRYLIC - CATE04=ACRYLIC&VENEER-CATE03=Veneer&PAINT-CATE02=PAINT"
7760
777 s.set_attribute "dynamic_attributes","c2_material_door_use_cat_core", "HDHMR"
778 s.set_attribute "dynamic_attributes","_c2_material_door_use_cat_core_label", "c2_material_door_use_cat_core"
7790
7800
781 s.set_attribute "dynamic_attributes","_c2_material_door_use_cat_core_access", "LIST"
782 s.set_attribute "dynamic_attributes","_c2_material_door_use_cat_core_formlabel", "DOOR CORE"
7830
784 s.set_attribute "dynamic_attributes","_c2_material_door_use_cat_core_options", "Plywood-CATC04=Plywood&ParticleBoard - CATC02=PARTICLEBOARD&HDHMR-CATC01=HDHMR"
7850
786 s.set_attribute "dynamic_attributes","c2_material_door_use_face_edge", "N/A"
787 s.set_attribute "dynamic_attributes","_c2_material_door_use_face_edge_label", "c2_material_door_use_face_edge"
7880
7890
7900
7910
7920
7930
7940
795 s.set_attribute "dynamic_attributes","c2_material_door_use_idcore", "HDHMR-01-CORE05"
796 s.set_attribute "dynamic_attributes","_c2_material_door_use_idcore_label", "c2_material_door_use_idcore"
7970
7980
799 s.set_attribute "dynamic_attributes","_c2_material_door_use_idcore_access", "LIST"
800 s.set_attribute "dynamic_attributes","_c2_material_door_use_idcore_formlabel", "DOOR CORE"
8010
802 s.set_attribute "dynamic_attributes","_c2_material_door_use_idcore_options", "HDHMR-01-CORE05=HDHMR-01&HDHMR-02-CORE21=HDHMR-02"
803
804 s.set_attribute "dynamic_attributes","c3_a", "Door"
805 s.set_attribute "dynamic_attributes","_c3_a_label", "c3_a"
8060
807
8080
8090
8100
8110
812
813 s.set_attribute "dynamic_attributes","c4_a", "Carcase"
814 s.set_attribute "dynamic_attributes","_c4_a_label", "c4_a"
8150
816
8170
8180
8190
8200
821ast123 = 'A2_BacThickness+A3_BackInset'
822 s.set_attribute "dynamic_attributes","cbackinset", "=A2_BacThickness+A3_BackInset"
823 s.set_attribute "dynamic_attributes","_cbackinset_label", "cbackinset"
824 s.set_attribute "dynamic_attributes","_cbackinset_formulaunits", "CENTIMETERS"
825 s.set_attribute "dynamic_attributes","_cbackinset_formula", ast123
8260
8270
828 s.set_attribute "dynamic_attributes","_cbackinset_units", "CENTIMETERS"
8290
8300
831 s.set_attribute "dynamic_attributes","cfrontclear", 3/2.54
832 s.set_attribute "dynamic_attributes","_cfrontclear_label", "cfrontclear"
833 s.set_attribute "dynamic_attributes","_cfrontclear_formulaunits", "CENTIMETERS"
8340
8350
8360
837 s.set_attribute "dynamic_attributes","_cfrontclear_units", "CENTIMETERS"
8380
839ast125 = 'LenZ-A3_PullPlaceY'
840 s.set_attribute "dynamic_attributes","cpullloch", "=LenZ-aPullInsetH"
841 s.set_attribute "dynamic_attributes","_cpullloch_label", "cpullloch"
842 s.set_attribute "dynamic_attributes","_cpullloch_formulaunits", "CENTIMETERS"
843 s.set_attribute "dynamic_attributes","_cpullloch_formula", ast125
8440
8450
846 s.set_attribute "dynamic_attributes","_cpullloch_units", "CENTIMETERS"
8470
848ast126 = '((LenX/2)-cSRStileW/2)'
849 s.set_attribute "dynamic_attributes","cpulllocw", "=IF(DRPNL_01!COPY=1,-1,1)*((LenX/2)-cSRStileW/2)"
850 s.set_attribute "dynamic_attributes","_cpulllocw_label", "cpulllocw"
851 s.set_attribute "dynamic_attributes","_cpulllocw_formulaunits", "CENTIMETERS"
852 s.set_attribute "dynamic_attributes","_cpulllocw_formula", ast126
8530
8540
855 s.set_attribute "dynamic_attributes","_cpulllocw_units", "CENTIMETERS"
8560
8570
858 s.set_attribute "dynamic_attributes","crevbottom", 0/2.54
859 s.set_attribute "dynamic_attributes","_crevbottom_label", "crevbottom"
860 s.set_attribute "dynamic_attributes","_crevbottom_formulaunits", "CENTIMETERS"
8610
8620
8630
864 s.set_attribute "dynamic_attributes","_crevbottom_units", "CENTIMETERS"
8650
8660
867 s.set_attribute "dynamic_attributes","crevedge", 0.1/2.54
868 s.set_attribute "dynamic_attributes","_crevedge_label", "crevedge"
869 s.set_attribute "dynamic_attributes","_crevedge_formulaunits", "CENTIMETERS"
8700
8710
8720
873 s.set_attribute "dynamic_attributes","_crevedge_units", "CENTIMETERS"
8740
8750
876 s.set_attribute "dynamic_attributes","crevtop", 0.5/2.54
877 s.set_attribute "dynamic_attributes","_crevtop_label", "crevtop"
878 s.set_attribute "dynamic_attributes","_crevtop_formulaunits", "CENTIMETERS"
8790
8800
8810
882 s.set_attribute "dynamic_attributes","_crevtop_units", "CENTIMETERS"
8830
8840
885 s.set_attribute "dynamic_attributes","csrbtmrailw", 6.4/2.54
886 s.set_attribute "dynamic_attributes","_csrbtmrailw_label", "csrbtmrailw"
887 s.set_attribute "dynamic_attributes","_csrbtmrailw_formulaunits", "CENTIMETERS"
8880
8890
8900
891 s.set_attribute "dynamic_attributes","_csrbtmrailw_units", "CENTIMETERS"
8920
893ast131 = 'A3_PullPlaceX*2'
894 s.set_attribute "dynamic_attributes","csrstilew", "=A3_PullPlaceX*2"
895 s.set_attribute "dynamic_attributes","_csrstilew_label", "csrstilew"
896 s.set_attribute "dynamic_attributes","_csrstilew_formulaunits", "CENTIMETERS"
897 s.set_attribute "dynamic_attributes","_csrstilew_formula", ast131
8980
8990
900 s.set_attribute "dynamic_attributes","_csrstilew_units", "CENTIMETERS"
9010
9020
903 s.set_attribute "dynamic_attributes","csrtoprailw", 6.4/2.54
904 s.set_attribute "dynamic_attributes","_csrtoprailw_label", "csrtoprailw"
905 s.set_attribute "dynamic_attributes","_csrtoprailw_formulaunits", "CENTIMETERS"
9060
9070
9080
909 s.set_attribute "dynamic_attributes","_csrtoprailw_units", "CENTIMETERS"
9100
9110
912 s.set_attribute "dynamic_attributes","cuttype_carcase", "SG"
913 s.set_attribute "dynamic_attributes","_cuttype_carcase_label", "cuttype_carcase"
9140
9150
9160
9170
9180
9190
9200
921 s.set_attribute "dynamic_attributes","cuttype_door", "SG"
922 s.set_attribute "dynamic_attributes","_cuttype_door_label", "cuttype_door"
9230
9240
9250
9260
9270
9280
9290
930 s.set_attribute "dynamic_attributes","d", "Hardware Information"
931 s.set_attribute "dynamic_attributes","_d_label", "d"
9320
9330
9340
9350
9360
9370
938
939 s.set_attribute "dynamic_attributes","d1_group_carcase", "Carcase"
940 s.set_attribute "dynamic_attributes","_d1_group_carcase_label", "d1_group_carcase"
9410
9420
9430
9440
9450
9460
947
948 s.set_attribute "dynamic_attributes","d1_group_cus_door", "Custom Door"
949 s.set_attribute "dynamic_attributes","_d1_group_cus_door_label", "d1_group_cus_door"
9500
9510
9520
9530
9540
9550
9560
957 s.set_attribute "dynamic_attributes","d1_group_door", "Door"
958 s.set_attribute "dynamic_attributes","_d1_group_door_label", "d1_group_door"
9590
9600
9610
9620
9630
9640
9650
966 s.set_attribute "dynamic_attributes","idprice_bracket", "215"
967 s.set_attribute "dynamic_attributes","_idprice_bracket_label", "idprice_bracket"
968 s.set_attribute "dynamic_attributes","_idprice_bracket_formulaunits", "STRING"
9690
9700
9710
972 s.set_attribute "dynamic_attributes","_idprice_bracket_units", "STRING"
9730
9740
975 s.set_attribute "dynamic_attributes","idprice_doorpull", "85"
976 s.set_attribute "dynamic_attributes","_idprice_doorpull_label", "idprice_doorpull"
977 s.set_attribute "dynamic_attributes","_idprice_doorpull_formulaunits", "STRING"
9780
9790
9800
981 s.set_attribute "dynamic_attributes","_idprice_doorpull_units", "STRING"
9820
9830
984 s.set_attribute "dynamic_attributes","idprice_hinge", "59"
985 s.set_attribute "dynamic_attributes","_idprice_hinge_label", "idprice_hinge"
986 s.set_attribute "dynamic_attributes","_idprice_hinge_formulaunits", "STRING"
9870
9880
9890
990 s.set_attribute "dynamic_attributes","_idprice_hinge_units", "STRING"
9910
9920
993 s.set_attribute "dynamic_attributes","idprice_leg", "63"
994 s.set_attribute "dynamic_attributes","_idprice_leg_label", "idprice_leg"
995 s.set_attribute "dynamic_attributes","_idprice_leg_formulaunits", "STRING"
9960
9970
9980
999 s.set_attribute "dynamic_attributes","_idprice_leg_units", "STRING"
10000
10010
1002 s.set_attribute "dynamic_attributes","typecabinets", "B"
1003 s.set_attribute "dynamic_attributes","_typecabinets_label", "typecabinets"
10040
10050
10060
10070
10080
10090
10100
1011 s.set_attribute "dynamic_attributes","zedgeallowance", 5/2.54
1012 s.set_attribute "dynamic_attributes","_zedgeallowance_label", "zedgeallowance"
1013 s.set_attribute "dynamic_attributes","_zedgeallowance_formulaunits", "CENTIMETERS"
10140
10150
10160
1017 s.set_attribute "dynamic_attributes","_zedgeallowance_units", "CENTIMETERS"
10180
10190
1020 s.set_attribute "dynamic_attributes","zfact_rem", "HG"
1021 s.set_attribute "dynamic_attributes","_zfact_rem_label", "zfact_rem"
10220
10230
10240
10250
10260
10270
10280
1029 s.set_attribute "dynamic_attributes","zfact_rem01", "MINIFIX SET"
1030 s.set_attribute "dynamic_attributes","_zfact_rem01_label", "zfact_rem01"
10310
10320
10330
10340
10350
10360
1037ast147 = 'LenY-cBackInset'
1038 s.set_attribute "dynamic_attributes","zinsidedepth", "=LenY-cBackInset"
1039 s.set_attribute "dynamic_attributes","_zinsidedepth_label", "zinsidedepth"
1040 s.set_attribute "dynamic_attributes","_zinsidedepth_formulaunits", "CENTIMETERS"
1041 s.set_attribute "dynamic_attributes","_zinsidedepth_formula", ast147
10420
10430
1044 s.set_attribute "dynamic_attributes","_zinsidedepth_units", "CENTIMETERS"
10450
1046ast148 = 'LenZ-aToeBaseH-BOTTOM!LenZ-RAIL_A!LenZ'
1047 s.set_attribute "dynamic_attributes","zinsideheight", "=LenZ-aToeBaseH-BOTTOM!LenZ-RAIL_A!LenZ"
1048 s.set_attribute "dynamic_attributes","_zinsideheight_label", "zinsideheight"
1049 s.set_attribute "dynamic_attributes","_zinsideheight_formulaunits", "CENTIMETERS"
1050 s.set_attribute "dynamic_attributes","_zinsideheight_formula", ast148
10510
10520
1053 s.set_attribute "dynamic_attributes","_zinsideheight_units", "CENTIMETERS"
10540
1055ast149 = 'LenX-RIGHT_SIDE!LenZ-RIGHT_SIDE!LenZ'
1056 s.set_attribute "dynamic_attributes","zinsidewidth", "=LenX-RIGHT_SIDE!LenZ-RIGHT_SIDE!LenZ"
1057 s.set_attribute "dynamic_attributes","_zinsidewidth_label", "zinsidewidth"
1058 s.set_attribute "dynamic_attributes","_zinsidewidth_formulaunits", "CENTIMETERS"
1059 s.set_attribute "dynamic_attributes","_zinsidewidth_formula", ast149
10600
10610
1062 s.set_attribute "dynamic_attributes","_zinsidewidth_units", "CENTIMETERS"
10630
Final
 

Some videos you may like

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
48,165
Office Version
  1. 365
Platform
  1. Windows
How about
VBA Code:
Sub sekar()
   Range("A1", Range("A" & Rows.Count).End(xlUp)).AutoFilter 1, "<>", xlAnd, "<>0"
End Sub
 

MrSyyr

New Member
Joined
Apr 29, 2020
Messages
31
Office Version
  1. 2016
Platform
  1. Windows
Select the data
go to Data Tab > filter > custom filter and add the zero and blank filters
 

sekar_r24

New Member
Joined
Apr 18, 2020
Messages
26
Office Version
  1. 2013
Platform
  1. Windows
How about
VBA Code:
Sub sekar()
   Range("A1", Range("A" & Rows.Count).End(xlUp)).AutoFilter 1, "<>", xlAnd, "<>0"
End Sub
Hi, Mr.Fluff.,

Thanks, the code works like charm.,
Perfect. where i can i find best tutorials for the VBA, could you guide pls. Most online tutorials are standard and basic..
 

sekar_r24

New Member
Joined
Apr 18, 2020
Messages
26
Office Version
  1. 2013
Platform
  1. Windows

ADVERTISEMENT

Select the data
go to Data Tab > filter > custom filter and add the zero and blank filters
HI.,
This is manual method, i looked for VBA method, that Mr.Fluff has solved in the above thread.
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
48,165
Office Version
  1. 365
Platform
  1. Windows
You're welcome & thanks for the feedback.
As I've never done any tutorials, I cannot recommend anything.
 

Watch MrExcel Video

Forum statistics

Threads
1,114,119
Messages
5,546,042
Members
410,722
Latest member
Jojo3008
Top