I have a code that I am using to copy the same columns (A:F) from multiple files in the same folder. It executes without error, and loops through all of the .xls files in the folder. But it only returns results from the first file. Where is my error?
Thank you
Please Login or Register to view this content.
Run your macro step by step with F8 and check value of NRow in line
Please Login or Register to view this content.
If solved remember to mark Thread as solved
that code is working fine but next empty row is taking wrong thats it
try this code hope this will work
Please Login or Register to view this content.
Thanks - Naveed
-----------------------------
If the suggestion helps you, then Click * to Add Reputation
To Attach File: Go Advanced>>Manage Attachments>>Add Files (In Top Right Corner)>>SelectFiles>>.........Locate Your File(s)>>Upload Files>>Done (In Bottom Right)
1. Use [code] code tags [\code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
It doesn't like this portion of the codeSays subscript out of rangePlease Login or Register to view this content.
As far as looking at the NRow = NRow + DestRange.Rows.Count
I am unsure how to modify this?
Please Login or Register to view this content.
Last edited by patel45; 01-16-2014 at 03:19 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks