The attached workbook was working fine according to requirements in this thread:
HTML Code:
A new problem has surfaced that for the life of me I cannot figure out. The data for the first invoice is being copied along with the first line of the second invoice for some reason (see Worksheet 2 for what the problem looks like). All other invoices are correctly copied.
Any advise or help is appreciated.
Thank you in advance,
BigDawg15
trying changing the following
in the If i =1
change
to
Please Login or Register to view this content.
breaking down the first linePlease Login or Register to view this content.
Offset((Range("D1").End(xlDown).Row), 1) = offset(16,1)
so
d1.offset(16,1) = 1 + 16 = 17, offset to the right and xlup = 16
therefore imgRNG = A1:E16
Last edited by humdingaling; 11-27-2014 at 09:01 PM.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
humdingaling,
Looks like your suggested solution corrected the problem.
Thank you very much.
Cheers,
BigDawg15
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks