Hi Guys,
I just want to know what is wrong with my codes below. When I run it "Run-time error '13': Type mismatch" occur.
Thanks for the help.
Please Login or Register to view this content.
Hi Guys,
I just want to know what is wrong with my codes below. When I run it "Run-time error '13': Type mismatch" occur.
Thanks for the help.
Please Login or Register to view this content.
I also attached the sample file.
Drop the "s" at the end your lastrow line.
Wrong:
Right:Please Login or Register to view this content.
Please Login or Register to view this content.
Please click the * below if this helps
Hi JasperD,
Thanks for that. Another one after correcting, How can I copy specific range of data instead of entire row?
Last edited by weeeee0713; 04-06-2015 at 12:02 PM.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks