So I created this VBA Module
After a lot of time thinking about the logic it should have I can't even debug it cause I get a Type Mismatch error on this line: stockAvailable = CInt(Worksheets("4WEEKS").Cells(rowIndex, stockTracker).Value)
Please Login or Register to view this content.
Can someone plz help me out
Hi AlonQ,
Maybe use Int rather than CInt:
stockAvailable =Int(Worksheets("4WEEKS").Cells(rowIndex, stockTracker).Value)
there are no Strings in your declarations??
Last edited by xladept; 05-15-2013 at 03:55 PM.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Nope, its either a number o nothing at all
Or nevermid aparently the formula that's assigned to that cell puts a "" in the cell if the resulting sum is 0.... so I guess "" counts as a String?
Hi AlonQ,
Yes - The quotation marks around anything is the way we define a string, and to use the CInt,CSng,CDbl etc you must have a string.
Did using the Int rather than the CInt not work???
not so-CInt will work with numbers as wellOriginally Posted by xladept
perhaps
Please Login or Register to view this content.
Josie
if at first you don't succeed try doing it the way your wife told you to
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks