Hello everyone
I have a range in which I need to sum the total and this is the code till now
I just need help at that point ::''Need to get the total for the item![]()
Please Login or Register to view this content.
Thanks advanced for help
Hello everyone
I have a range in which I need to sum the total and this is the code till now
I just need help at that point ::''Need to get the total for the item![]()
Please Login or Register to view this content.
Thanks advanced for help
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
![]()
Please Login or Register to view this content.
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.
Thank you very much AlphaFrog .. That solved the problem
But I need to understand this point as I can't get it
dic.Item(k)(1)
This returns the key value for Item(k) in the dictionary. The key, in this case, is a zero-based one-dimensional array with two elements. Element(0) in the array is the the same as the Item(k). Element (1) in the array is the total. The (1) on the end references the second element in the array. I hope that helps. I don't know how else to explain it.
I'm not sure why the key value is made as an array in the first place. An array is not needed as the first element in the array is just duplicate of the Item value.
Thank you very much for this great explanation. I could get it now
In fact array used because there are other fields that will be added not just two fields .. I just wanted to simplify the issue
Best Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks