Filter the values.

[sekar_r24]

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
1	Data
2	0
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"
6	0
7	s.set_attribute "dynamic_attributes","_lenx_access", "NONE"
8	0
9	0
10	0
11	0
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"
15	0
16	s.set_attribute "dynamic_attributes","_leny_access", "NONE"
17	0
18	0
19	0
20	0
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"
24	0
25	s.set_attribute "dynamic_attributes","_lenz_access", "NONE"
26	0
27	0
28	0
29	0
30	s.set_attribute "dynamic_attributes","a", "Parameter"
31	s.set_attribute "dynamic_attributes","_a_label", "a"
32	0
33	0
34	0
35	0
36	0
37	0
38	0
39	s.set_attribute "dynamic_attributes","a0_item", "0"
40	s.set_attribute "dynamic_attributes","_a0_item_label", "a0_item"
41	0
42	0
43	0
44	0
45	0
46	0
47	0
48	s.set_attribute "dynamic_attributes","a0_label", "0"
49	s.set_attribute "dynamic_attributes","_a0_label_label", "a0_label"
50	0
51	0
52	0
53	0
54	0
55	0
56	0
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"
60	0
61	s.set_attribute "dynamic_attributes","_a0_type_access", "LIST"
62	s.set_attribute "dynamic_attributes","_a0_type_formlabel", "CABINET_TYPE"
63	0
64	s.set_attribute "dynamic_attributes","_a0_type_options", "MODULAR=1&SEMI-MODULAR=2"
65	0
66	s.set_attribute "dynamic_attributes","a1_a", "Size"
67	s.set_attribute "dynamic_attributes","_a1_a_label", "a1_a"
68	0
69	0
70	0
71	0
72	0
73	0
74	0
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"
78	0
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"
82	0
83	ast09 = '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
88	0
89	0
90	0
91	0
92	0
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"
96	0
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"
100	0
101	0
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"
105	0
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"
109	0
110	0
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"
114	0
115	0
116	0
117	s.set_attribute "dynamic_attributes","_a1_shutterht_s_units", "MILLIMETERS"
118	0
119	0
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"
123	0
124	0
125	0
126	s.set_attribute "dynamic_attributes","_a1_width_units", "MILLIMETERS"
127	0
128	0
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"
132	0
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"
136	0
137	0
138	s.set_attribute "dynamic_attributes","a2_a", "Thickness"
139	s.set_attribute "dynamic_attributes","_a2_a_label", "a2_a"
140	0
141	0
142	0
143	0
144	0
145	0
146	0
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"
150	0
151	0
152	0
153	s.set_attribute "dynamic_attributes","_a2_bacthickness_units", "CENTIMETERS"
154	0
155	0
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"
159	0
160	0
161	0
162	s.set_attribute "dynamic_attributes","_a2_carthickness_units", "CENTIMETERS"
163	0
164	0
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"
168	0
169	0
170	0
171	s.set_attribute "dynamic_attributes","_a2_doothickness_units", "CENTIMETERS"
172	0
173	0
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"
177	0
178	0
179	0
180	s.set_attribute "dynamic_attributes","_a2_zrevbottom_units", "CENTIMETERS"
181	0
182	0
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"
186	0
187	0
188	0
189	s.set_attribute "dynamic_attributes","_a2_zrevedge_units", "CENTIMETERS"
190	0
191	0
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"
195	0
196	0
197	0
198	s.set_attribute "dynamic_attributes","_a2_zrevtop_units", "CENTIMETERS"
199	0
200	0
201	s.set_attribute "dynamic_attributes","a3", "Style"
202	s.set_attribute "dynamic_attributes","_a3_label", "a3"
203	0
204	0
205	0
206	0
207	0
208	0
209	0
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"
213	0
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"
218	0
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"
221	0
222	0
223	0
224	0
225	0
226	0
227	0
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"
230	0
231	0
232	0
233	0
234	0
235	0
236	0
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"
239	0
240	0
241	0
242	0
243	0
244	0
245	0
246	s.set_attribute "dynamic_attributes","a3_amaterial_dorl", "LIGHT"
247	s.set_attribute "dynamic_attributes","_a3_amaterial_dorl_label", "a3_amaterial_dorl"
248	0
249	0
250	s.set_attribute "dynamic_attributes","_a3_amaterial_dorl_access", "LIST"
251	s.set_attribute "dynamic_attributes","_a3_amaterial_dorl_formlabel", "CARCASS_EXPOSED"
252	0
253	s.set_attribute "dynamic_attributes","_a3_amaterial_dorl_options", "DARK=DARK&LIGHT=LIGHT"
254	ast28 = '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
259	0
260	0
261	s.set_attribute "dynamic_attributes","_a3_amaterial_dorl1_units", "STRING"
262	0
263	0
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"
267	0
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"
272	0
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"
276	0
277	0
278	0
279	s.set_attribute "dynamic_attributes","_a3_aqtyshelf_units", "STRING"
280	0
281	ast31 = '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
286	0
287	0
288	s.set_attribute "dynamic_attributes","_a3_backinset_units", "CENTIMETERS"
289	0
290	0
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"
294	0
295	0
296	0
297	s.set_attribute "dynamic_attributes","_a3_backinset_s_units", "CENTIMETERS"
298	0
299	ast33 = '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
304	0
305	0
306	s.set_attribute "dynamic_attributes","_a3_backpaneloffset_units", "CENTIMETERS"
307	0
308	0
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"
312	0
313	0
314	0
315	s.set_attribute "dynamic_attributes","_a3_backpaneloffset_s_units", "CENTIMETERS"
316	0
317	0
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"
321	0
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"
326	0
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"
330	0
331	0
332	0
333	s.set_attribute "dynamic_attributes","_a3_cfrontclear_units", "CENTIMETERS"
334	0
335	0
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"
339	0
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"
344	0
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"
348	0
349	0
350	0
351	s.set_attribute "dynamic_attributes","_a3_cncpanotype_units", "STRING"
352	0
353	0
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"
357	0
358	0
359	0
360	s.set_attribute "dynamic_attributes","_a3_edgthiofedgdoor_units", "CENTIMETERS"
361	0
362	0
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"
366	0
367	0
368	0
369	s.set_attribute "dynamic_attributes","_a3_froraiangle_units", "STRING"
370	0
371	0
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"
375	0
376	0
377	0
378	s.set_attribute "dynamic_attributes","_a3_froraiwidth_units", "CENTIMETERS"
379	0
380	0
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"
384	0
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"
389	0
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"
393	0
394	0
395	0
396	s.set_attribute "dynamic_attributes","_a3_heiofgappull_units", "CENTIMETERS"
397	0
398	0
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"
402	0
403	0
404	0
405	s.set_attribute "dynamic_attributes","_a3_heioflonpull_units", "CENTIMETERS"
406	0
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
412	0
413	0
414	s.set_attribute "dynamic_attributes","_A3_heiofaledPull_units", "CENTIMETERS"
415	0
416	0
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"
420	0
421	0
422	0
423	s.set_attribute "dynamic_attributes","_a3_heiofstdpull_units", "CENTIMETERS"
424	0
425	0
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"
429	0
430	0
431	0
432	s.set_attribute "dynamic_attributes","_a3_hintype_units", "STRING"
433	0
434	0
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"
438	0
439	0
440	0
441	s.set_attribute "dynamic_attributes","_a3_pullplacex_units", "CENTIMETERS"
442	0
443	0
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"
447	0
448	0
449	0
450	s.set_attribute "dynamic_attributes","_a3_pullplacey_units", "CENTIMETERS"
451	0
452	0
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"
456	0
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"
461	0
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"
465	0
466	0
467	0
468	s.set_attribute "dynamic_attributes","_a3_topedgeangleingappull_units", "CENTIMETERS"
469	0
470	0
471	s.set_attribute "dynamic_attributes","a4", "Customise"
472	s.set_attribute "dynamic_attributes","_a4_label", "a4"
473	0
474	0
475	0
476	0
477	0
478	0
479	ast65 = '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
484	0
485	0
486	s.set_attribute "dynamic_attributes","_a5_doorpull_units", "CENTIMETERS"
487	0
488	0
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"
492	0
493	0
494	0
495	s.set_attribute "dynamic_attributes","_a5_doorpull_s_units", "STRING"
496	0
497	0
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"
501	0
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"
506	0
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"
510	0
511	0
512	0
513	s.set_attribute "dynamic_attributes","_a5_jhandletype_units", "STRING"
514	0
515	0
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"
519	0
520	0
521	0
522	s.set_attribute "dynamic_attributes","_a6_addon_units", "STRING"
523	0
524	0
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"
528	0
529	0
530	0
531	s.set_attribute "dynamic_attributes","_adoorhand_units", "STRING"
532	0
533	0
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"
537	0
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"
542	ast72 = '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
547	0
548	0
549	s.set_attribute "dynamic_attributes","_apullinseth_units", "CENTIMETERS"
550	0
551	0
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"
555	0
556	0
557	0
558	s.set_attribute "dynamic_attributes","_apullinsetw_units", "CENTIMETERS"
559	0
560	0
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"
564	0
565	0
566	0
567	s.set_attribute "dynamic_attributes","_atoebaseh_units", "CENTIMETERS"
568	0
569	0
570	s.set_attribute "dynamic_attributes","c", "Material_Code"
571	s.set_attribute "dynamic_attributes","_c_label", "c"
572	0
573	0
574	0
575	0
576	0
577	0
578	0
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"
582	0
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"
587	0
588	s.set_attribute "dynamic_attributes","c2_material_carcase", "Laminate"
589	s.set_attribute "dynamic_attributes","_c2_material_carcase_label", "c2_material_carcase"
590	0
591	0
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"
594	0
595	s.set_attribute "dynamic_attributes","_c2_material_carcase_options", "Lam_IDLIST01=Laminate&Paint_IDLIST02=PU-Lacquer_Paint&VENEER_IDLIST03=Veneer&SW_IDLIST04=Solidwood"
596	0
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"
600	0
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"
605	0
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"
608	0
609	0
610	0
611	0
612	0
613	0
614	0
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"
617	0
618	0
619	0
620	0
621	0
622	0
623	0
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"
626	0
627	0
628	0
629	0
630	0
631	0
632	0
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"
635	0
636	0
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"
639	0
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"
641	0
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"
644	0
645	0
646	0
647	0
648	0
649	0
650	0
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"
653	0
654	0
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)"
657	0
658	0
659	0
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"
662	0
663	0
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)"
666	0
667	0
668	0
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"
671	0
672	0
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)"
675	0
676	0
677	0
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"
680	0
681	0
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"
684	0
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"
686	0
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"
689	0
690	0
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"
693	0
694	s.set_attribute "dynamic_attributes","_c2_material_carcase_use_cat_core_options", "Plywood-CATC04=Plywood&ParticleBoard - CATC02=PARTICLEBOARD&HDHMR-CATC01=HDHMR"
695	0
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"
698	0
699	0
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"
702	0
703	s.set_attribute "dynamic_attributes","_c2_material_carcase_use_idcore_options", "Plywood-BWR-CORE05=Plywood-BWR&Plywood-Commercial-CORE21=Plywood-Commercial"
704	0
705	s.set_attribute "dynamic_attributes","c2_material_door", "Laminate"
706	s.set_attribute "dynamic_attributes","_c2_material_door_label", "c2_material_door"
707	0
708	0
709	s.set_attribute "dynamic_attributes","_c2_material_door_access", "LIST"
710	s.set_attribute "dynamic_attributes","_c2_material_door_formlabel", "DOOR FINISH - TYPE"
711	0
712	s.set_attribute "dynamic_attributes","_c2_material_door_options", "Lam_IDLIST01=Laminate&Paint_IDLIST02=PU-Lacquer_Paint&VENEER_IDLIST03=Veneer&SW_IDLIST04=Solidwood"
713	0
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"
716	0
717	0
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"
720	0
721	s.set_attribute "dynamic_attributes","_c2_material_door_bandplane_options", "2M are Same=1M&2M are Different=2M"
722	0
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"
725	0
726	0
727	0
728	0
729	0
730	0
731	0
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"
734	0
735	0
736	0
737	0
738	0
739	0
740	0
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"
743	0
744	0
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"
747	0
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"
749	0
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"
752	0
753	0
754	0
755	0
756	0
757	0
758	0
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"
761	0
762	0
763	0
764	0
765	0
766	0
767	0
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"
770	0
771	0
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"
774	0
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"
776	0
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"
779	0
780	0
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"
783	0
784	s.set_attribute "dynamic_attributes","_c2_material_door_use_cat_core_options", "Plywood-CATC04=Plywood&ParticleBoard - CATC02=PARTICLEBOARD&HDHMR-CATC01=HDHMR"
785	0
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"
788	0
789	0
790	0
791	0
792	0
793	0
794	0
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"
797	0
798	0
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"
801	0
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"
806	0
807
808	0
809	0
810	0
811	0
812
813	s.set_attribute "dynamic_attributes","c4_a", "Carcase"
814	s.set_attribute "dynamic_attributes","_c4_a_label", "c4_a"
815	0
816
817	0
818	0
819	0
820	0
821	ast123 = '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
826	0
827	0
828	s.set_attribute "dynamic_attributes","_cbackinset_units", "CENTIMETERS"
829	0
830	0
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"
834	0
835	0
836	0
837	s.set_attribute "dynamic_attributes","_cfrontclear_units", "CENTIMETERS"
838	0
839	ast125 = '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
844	0
845	0
846	s.set_attribute "dynamic_attributes","_cpullloch_units", "CENTIMETERS"
847	0
848	ast126 = '((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
853	0
854	0
855	s.set_attribute "dynamic_attributes","_cpulllocw_units", "CENTIMETERS"
856	0
857	0
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"
861	0
862	0
863	0
864	s.set_attribute "dynamic_attributes","_crevbottom_units", "CENTIMETERS"
865	0
866	0
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"
870	0
871	0
872	0
873	s.set_attribute "dynamic_attributes","_crevedge_units", "CENTIMETERS"
874	0
875	0
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"
879	0
880	0
881	0
882	s.set_attribute "dynamic_attributes","_crevtop_units", "CENTIMETERS"
883	0
884	0
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"
888	0
889	0
890	0
891	s.set_attribute "dynamic_attributes","_csrbtmrailw_units", "CENTIMETERS"
892	0
893	ast131 = '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
898	0
899	0
900	s.set_attribute "dynamic_attributes","_csrstilew_units", "CENTIMETERS"
901	0
902	0
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"
906	0
907	0
908	0
909	s.set_attribute "dynamic_attributes","_csrtoprailw_units", "CENTIMETERS"
910	0
911	0
912	s.set_attribute "dynamic_attributes","cuttype_carcase", "SG"
913	s.set_attribute "dynamic_attributes","_cuttype_carcase_label", "cuttype_carcase"
914	0
915	0
916	0
917	0
918	0
919	0
920	0
921	s.set_attribute "dynamic_attributes","cuttype_door", "SG"
922	s.set_attribute "dynamic_attributes","_cuttype_door_label", "cuttype_door"
923	0
924	0
925	0
926	0
927	0
928	0
929	0
930	s.set_attribute "dynamic_attributes","d", "Hardware Information"
931	s.set_attribute "dynamic_attributes","_d_label", "d"
932	0
933	0
934	0
935	0
936	0
937	0
938
939	s.set_attribute "dynamic_attributes","d1_group_carcase", "Carcase"
940	s.set_attribute "dynamic_attributes","_d1_group_carcase_label", "d1_group_carcase"
941	0
942	0
943	0
944	0
945	0
946	0
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"
950	0
951	0
952	0
953	0
954	0
955	0
956	0
957	s.set_attribute "dynamic_attributes","d1_group_door", "Door"
958	s.set_attribute "dynamic_attributes","_d1_group_door_label", "d1_group_door"
959	0
960	0
961	0
962	0
963	0
964	0
965	0
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"
969	0
970	0
971	0
972	s.set_attribute "dynamic_attributes","_idprice_bracket_units", "STRING"
973	0
974	0
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"
978	0
979	0
980	0
981	s.set_attribute "dynamic_attributes","_idprice_doorpull_units", "STRING"
982	0
983	0
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"
987	0
988	0
989	0
990	s.set_attribute "dynamic_attributes","_idprice_hinge_units", "STRING"
991	0
992	0
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"
996	0
997	0
998	0
999	s.set_attribute "dynamic_attributes","_idprice_leg_units", "STRING"
1000	0
1001	0
1002	s.set_attribute "dynamic_attributes","typecabinets", "B"
1003	s.set_attribute "dynamic_attributes","_typecabinets_label", "typecabinets"
1004	0
1005	0
1006	0
1007	0
1008	0
1009	0
1010	0
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"
1014	0
1015	0
1016	0
1017	s.set_attribute "dynamic_attributes","_zedgeallowance_units", "CENTIMETERS"
1018	0
1019	0
1020	s.set_attribute "dynamic_attributes","zfact_rem", "HG"
1021	s.set_attribute "dynamic_attributes","_zfact_rem_label", "zfact_rem"
1022	0
1023	0
1024	0
1025	0
1026	0
1027	0
1028	0
1029	s.set_attribute "dynamic_attributes","zfact_rem01", "MINIFIX SET"
1030	s.set_attribute "dynamic_attributes","_zfact_rem01_label", "zfact_rem01"
1031	0
1032	0
1033	0
1034	0
1035	0
1036	0
1037	ast147 = '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
1042	0
1043	0
1044	s.set_attribute "dynamic_attributes","_zinsidedepth_units", "CENTIMETERS"
1045	0
1046	ast148 = '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
1051	0
1052	0
1053	s.set_attribute "dynamic_attributes","_zinsideheight_units", "CENTIMETERS"
1054	0
1055	ast149 = '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
1060	0
1061	0
1062	s.set_attribute "dynamic_attributes","_zinsidewidth_units", "CENTIMETERS"
1063	0
Final

 

[Fluff]

How about

Sub sekar()
   Range("A1", Range("A" & Rows.Count).End(xlUp)).AutoFilter 1, "<>", xlAnd, "<>0"
End Sub

 

[MrSyyr]

Select the data
go to Data Tab > filter > custom filter and add the zero and blank filters

 

[sekar_r24]

How about

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]

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]

You're welcome & thanks for the feedback.
As I've never done any tutorials, I cannot recommend anything.

 

[sekar_r24]

You're welcome & thanks for the feedback.
As I've never done any tutorials, I cannot recommend anything.