Hi Shrinivas, Mr. Powell has rightly said, please debug the same way. And If it helps please also check, if you have larger amount of columns or rows than your friend, since this also cause "Subscript Out of Range". Run on lesser or same amount of rows , also ensure correct sheet/file names in the vba macro.
For more tips, tricks, downloads and problem solutions: visit --> http://www.excelitems.com ------------------------------------------------------------------------ Regards *Ashish **Jain* Analyst, CSC Microsoft Certified Application (Excel) Specialist Excel and VBA Trainer Author -> www.excelitems.com +91-9999-40-48-43 ------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------- On Apr 1, 2:54 pm, shrinivas shevde <shrinivas...@hotmail.com> wrote: > Dear All > > I am having vba code not written by me but one of my friend.Now I am facing a > problem while running the same. > > This I am using to make a monthly report ,this programe open a indivisual > file from the given folsder and copy paste required data in given excel sheet. > > Now when I am try to run this it shows the > > Run-time error9' > Subscript out of range > > Please help me to solve this problem > > shrinivas > > _________________________________________________________________ > So many new options, so little time. Windows Live > Messenger.http://www.microsoft.com/india/windows/windowslive/messenger.aspx --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---