LinkBack URL
About LinkBacks
any though here ...type mismatch on date.
Please Login or Register to view this content.
any though here ...type mismatch on date.
Please Login or Register to view this content.
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
It looks like you are comparing a string to a date. A date is a number.
This would produce the same error...
How is MyDate declared and set?Please Login or Register to view this content.
What exactly is in rep.Offset(0, 2).Value? A Serial date or a Text-date?
How is replace declared?
Last edited by AlphaFrog; 07-29-2013 at 09:23 PM.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
you mean the offset is returning a string instead of the number(date).
i checked the dates they are numbers(i tried to add ) also formatted as *3/14/2001
They are Serial dates
Please Login or Register to view this content.
MyDate is a Date.Please Login or Register to view this content.
replace is a string and not a date.
lol, Why did not I see that I was going round and round...
Thank you very much.
You're welcome.
Also note;
In this declaration, only rep is type Range. Rng1 and Rng2 are both type variant unless you explicitly declare the type for each e.g.;Please Login or Register to view this content.
Please Login or Register to view this content.
yup. thanks again.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks