Hi Friends,
Iam new to Excel VBA and still learning.
Problem: One of the step in that project is, In the Userform , by one button click i have to update some of the columns in the "All" sheet. I did my part ,by try using 'For -with loop' Code for my "product hireachy" column and "Flow Description"column and I can still get my answer but they run very slow and some time not responding too.so i tried to use some speed loop but still the same .In "All" sheet,after I clicked Update button,I also can see some '#NA ' for those rows that don't have Material no and Partid,which i don't want to see.
Program flow: Every week ,From Yc55 i have to manually copy and paste few material no and Part id into the "All" tab then i open my Userform click "UPDATE" button it will update my columns like "product hireachy" ,Product ,mask layer ,metal layer,poly layer "Flow Description"
Please Help me !! your help is appreciated ...Thank You !!
http://www.ozgrid.com/forum/showthread.php?t=177009
Below i attached my file, pls take a look at it.
Bookmarks