Hi All,
I was using the below code to extract data and pasting it in another sheet called Result
Now today I added 2 extra rows and I am getting the Type mismatch error at line "Set frng = Sheets("result").Range("A:A").Find(CDate(fdate))"
I have tried amending the i = 1137 because from thats where the 2 rows are being added and hence amended the Irow Step 14
But it still gives the same error
Can anybody please help to troubleshoot
Please Login or Register to view this content.
Last edited by logisticsexcel; 05-29-2017 at 07:55 AM.
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.
Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.
Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here
Hi logistixexcel
Your steps are 12, 14, 13
Is this the norm and are they repeated....
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!!!
The problem is that fdate is an empty string because B22 is empty.
If posting code please use code tags, see here.
Hi- Not sure what the FORMAT >> CDATE thing was about. I took it out and the type mismatch disappeared.Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-LeePlease Login or Register to view this content.
Last edited by leelnich; 05-29-2017 at 12:29 PM.
Sort out your 14 step and then this code has been tested and works:
So date in row 2 then 16 then 30
Please Login or Register to view this content.
Thanks all for your help.
It works now
Glad we could help. Thanks for the rep point.
Type mismatch error
All my macros were working properly on windows7 Excel 2003 Excel 2007, Excel 2010
None are working on windows10 Excel 2016 or even on Excel 2007
My scripts are too long, numerous to fix every bugs.
Is there a solution to get Windows10 fix in order to run those script as before on windows7
Marcel
mdleclerc
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
PS It's unlikely the errors you are receiving are a version issue.
I am searching for the last 15 minutes, I cannot find were is new Thread
Marcel, I think he means you should start your OWN thread, and perhaps include a link to this one in THAT. To start a thread, go to the Home page, select the appropriate Forum (just 1; do not cross-post) and click the blue + Post New Thread button.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks