LinkBack URL
About LinkBacks
Hi, wondering is there a VBA equivalent of --() in excel that turns trues and falses to 1's and 0's?
Hi, wondering is there a VBA equivalent of --() in excel that turns trues and falses to 1's and 0's?
Last edited by cmore; 06-21-2014 at 09:24 AM.
True * -1 = 1
False * -1 = 0
Ben Van Johnson
Do you mean like this:
Robert
Please Login or Register to view this content.
____________________________________________
Please ensure you mark your thread as Solved once it is. Click here to see how
If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
The conversion functions CLng, CDbl etc wil convert from boolean.
Last edited by mikerickson; 06-21-2014 at 03:47 AM.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
Thanks Guys, but I realized I'm unclear, I guess the question should be how do you convert boolean array to an integer array?
How are you creating the boolean array?
If posting code please use code tags, see here.
Norie, how's it going boss. I'm taking an array from a range and loading into an array and then using Application.Index(Bigarray, 0, 1) to get the subarray. A while ago you came up with doing this
I think the only limitation with this was the character maximum for Evaluate, which was an issue for my other application but works for the one I'm currently working on. I was just wondering if there's anything else more direct, as the other convention of pushing to a named range, then pushing back to vba and deleting that name is a bit painfulPlease Login or Register to view this content.
Last edited by cmore; 06-21-2014 at 01:03 PM.
Are you sure that's for converting boolean to integer?
When I try it with a boolean array populated via code it doesn't work, thought it will work if the boolean values are actually strings, ie 'True'/'False'.
Can you give more details on what you are actually trying to do?
Yeah, it's definitely boolean array turned to string using join, only thing is that I transpose it to get to a 1-D array first result: "True,True,True,True,True".
My Problem is manipulating data against multiple conditions quickly and without having to write tons of line of code. I am finding myself basically doing this task a number of times one way or the other and just hoping to figure out an efficient way of doing things.
Right now I basically load a set of data into an array work in it in VBA push it to a Named Range push it back to VBA work on it a little more and then push it back to excel. This keeps the file relatively light, and minimizes some user input errors, but just hoping for a more direct solution
Can you post the code you are using to get/populate the boolean array?
Yessir
Please Login or Register to view this content.
Perhaps something like this will work for you
Please Login or Register to view this content.
Thanks mikerickson, the only thing is in most cases I try to only reference the worksheet once. So I'll load a data set into an array, and then will manipulate the data in vba before putting it back into the sheet
I'm suggesting that you reference the worksheet cells only once. Get both the boolean and the numeric array with one range reference.
Gotchya, I see what you're saying, problem is the range that I initially pull in has varying data types not just boolean. So for instance I'll grab all the data from a work sheet and then just need to summarize it in different ways based on other inputs or limit inputs in other areas in the workbook.
So right now it really looks the take the VBA generated Boolean array and pushing it to a named range and then evaluating that named range into the VBA array and then deleting the named range is the most dynamic (non-looping) way of conversion. The Join * Evaluate mechanism fails when you have just one element, so you'd have to write a condition. but if I knew there would always be >1 Join * Evaluate seems pretty awesome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks