I have objects with serial numbers, example 230, 231, 232, 233 ... Is there a function that can count how many object are from 231 to 278 for example. It can be done with subtracting 278 and 231, and adding 1. But I am wondering is there some function to do this because I need it to be more simple.
Thanks a lot!
Hello noctornus,
Objects have names but depending on the object may have a caption or value property. Which property are these serial numbers applied to?
You really cannot get simpler than using addition and subtraction. You could make it more convenient by creating a function like below.
Function ObjectCount(ByVal First_SerialNumber, ByVal Last_SerialNumber) ObjectCount = ABS(Last_SerialNumber - First_SerialNumber + 1) End Function
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks