The attached is a worksheet that I'm working with, actually the data runs to over 100,000 lines, but I have shortened the example. Macro1 contains a formula that I wish to place into cells D4 to E9, then copy and paste to the end of the data.
Note, each block is a set of 5 line for one part, so the formulas in line D4 to E9 are different. And must be copied in sets. I can do it manually, but the macro will not work. Currently I get an error when the process runs, but I don't know if my program language in not correct, or is Visual Basic cannot do. Any suggestions? Would removing the blank rows help? Any support would be appreciated. Thanks Dave David Pehrson Materials Manager, Lawn and Garden North America Walbro Engine Management, LLC 7400 North Oracle, Suite 311 Tucson, AZ 85704 Office (520) 229-5694 Cell (520) 780-1364 Fax (520) 877-3006 Confidentiality Notice: The materials contained within this e-mail transmission (including all attachments) are private and confidential and the property of the sender. The information contained in the materials is priveleged and intended only for the named addressee(s). If you are not the intended addressee, be advised that any unauthorized disclosure, copying, distribution or the taking of any action in reliance on the contents of this material is strictly prohibited. If you have received this e-mail transmission in error, please immediately notify the sender by telephone at 520-229-5694 or send an e-mail to dpehr...@walbro.com <mailto:jki...@walbro.com> and thereafter destroy the e-mail you received and all copies thereof. -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
<<image001.gif>>
wmx mrp with zero req Macro Test.xlsm
Description: wmx mrp with zero req Macro Test.xlsm
