Copy Row from one sheet to another
Hi,
I have 2 excel files. One act as an interface.xlsm n another as a database.xlsx
In interface.xlsm will run the VBA process which its open database.xlsx and find row which have "lotNo" and copy that row to SSMC(sheet3) sheets in database.xlsx.
The problem is the copy code below copy the row to sheet3 in interface.xlsm.
Please Login or Register to view this content.
Can you also mention what the problem is?
Cheers!
Tsjallie
--------
If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!
If you think design is an expensive waste of time, try doing without ...
Hi tanpa_nama
Ideally a sample workbook would assist us in solving your problem...possibly even perfect your code
Your code does not really specify any workbooks or sheets....This line of your code
should be something likePlease Login or Register to view this content.
Please Login or Register to view this content.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
I think the i in Cells(i, "D") has a value which which is invalid as a rownumber. Wanna bet?
Now that you mention it Tsjalie...Probably rightwhich is invalid as a rownumber
thanks.the problem is due to the size of copy paste area.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks