I get a type mismatch when trying to use the following in a module:
The error comes from the "Worksheets(fromsheet).Activate" line, and I suspect it will occur again when I use the tosheet argument. I call this procedure using the line of code:
Please Login or Register to view this content.
Where wobid and res are the names of sheets in my workbook. Any ideas why i get the error?Please Login or Register to view this content.
Thank you very much
I understand that you want to copy data from one sheet to the other. What is the condition for the copy?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
The condition is that column "S" has a value of "Completed"
I just noticed the middle part of the code should look like this.Please Login or Register to view this content.
In context, col1 is column S of my sheet wobid.
because fromsheet is a worksheet objectPlease Login or Register to view this content.
Last edited by arlu1201; 09-21-2012 at 12:45 PM.
Josie
if at first you don't succeed try doing it the way your wife told you to
JosephP you're an absolute genius.
Thank you
you're welcome :-)
Wait! one last question. I now try to add other criteria and it gives me the error again!!
I don't see the problem here! Please helpPlease Login or Register to view this content.
It highlights this portion with the type mismatch
Please Login or Register to view this content.
Post you excel file, I think I might have a solution to what you are trying to so. To be clear, you want your macro to check in column S to see if the value is "Completed", if so you want to copy that entire row to a new sheet?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks