Filing Macro - Simple ... It would seem
Hi All,
I'm trying to get a basic filing macro to work. I'm trying to copy a numeric value from one sheet to another. This is the code I have so far;
The code will only copy values from row D. It seems to be ignoring the E column, i.e. the Else argument.
Please Login or Register to view this content.
Any ideas what I can do to resolve this?
not seeing data it is just guessing. I expect in column E you have different values than you expect.
Try:
PS. Thread title shall be "executive summary of the problem - some people do use http://www.excelforum.com/search.php - think of them writing title pls.Please Login or Register to view this content.
Best Regards,
Kaper
It's seeing the data, it's placing '0' integers in the cells.
The first cell row source in the argument places the actual values in the required sheet i.e. E to D it places the E values and leaves a D as 0 and the inverse is also true.
Also, apologies. I'll be more comprehensive next time.Please Login or Register to view this content.
Last edited by WillJ; 04-10-2014 at 02:17 PM.
So it is writing 0s and shall some number? The one you stored in amount variable?
This is what I suggested to test with MsgBox. If it is, what happens - the code is right, the data is bad. May be thhere are extra spaces, may be it has comma as decimal separator (not dot) etc.etc.
Use appropriate "preprocessing" - may be Val or Trim or Cdbl and Replace or ....
Thanks for you help with this. I've got that issue resolved now, it was the "-" in the code that was causing the error. Many thanks : )
I've got an type mismatch error popping up. It's strange, in the test it appears to be working fine in both columns however in the actual application, even with the - taken out it is only filing the values from the first column i.e. "E" (the message box is displaying values from column E and the code is effectively sorting it to its the correct cells). Once it gets to a value in "D" the error occurs. Any ideas?
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