There's the sub. Basicly if cell that got changed is in A column and value in the cell isn't empty I want to set formula to B column of that cells row(and use cells value in formula). However it halts in the If clause claiming type mismatches.
Please Login or Register to view this content.
Where it is missing? My guess is that value but didn't range objects have value?
(btw how would this operate if more than one cell gets changed. Say copy&paste order?)
Last edited by tneva; 02-02-2009 at 07:31 AM.
Syntax looks OK to me. Is it only a single cell you are changing when the code fails? Just to be perfectly clear, please indicate exactly which line the code fails on and provide the exact error the debugger reports.
Richard
Richard Schollar
Microsoft MVP - Excel
Yes cell A251 is the one that change. It stops in the line with IF in it(2nd line) with runtime error 13: Type Mismatch.Originally Posted by RichardSchollar
No more information comes in error message.
And here's the line in full:
Edit: Seems to be target.value that is causing problems. Removed it, if clause passed, halts in same error in next line where there is, or atleast should be, yet another target.value(which is just a number like 424635).Please Login or Register to view this content.
Last edited by tneva; 02-02-2009 at 06:29 AM.
I get a type mismatch error if the Target range is more than 1 cell.
You can not check the Value of multiple cells.
That's odd since there should be only one cell changing :-( Though does mean this doesn't work anyway since just because now it should be one cell doesn't mean in future there won't be multiple lines added.
Oh bugger.
So you just need to code for multiple cells.
Should each row in the target range have a formula applied?
What is the proper formula?
Yes for every row where number gets added.
Formula is:
Where A303 is cell that got changed. Ultimately I will be wanting to change "*-200 day" to be date which is dependant on row above this which is why I'm going macro way(can't figure way to get it working by adding formula to cell itself. I can put date there but how to get it calculate from date above).Please Login or Register to view this content.
Result will be date and time.
So something more like this.
Change the formula to your formula with user defined functions.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks