Hello,
I have a variable called Table as a variant. In this table, there are strings and doubles. I have finished putting a bunch of strings and values and now I want to find how big it is (how many rows and columns it has). How do I do that?
I saw there is something for ranges by using range.address to find it's dimensions so how do I do something like that with my variant? If there is nothing like that I can do, how to i find how many rows and columns it has?
Last edited by ytjjjtyj; 06-25-2019 at 07:53 AM.
For a one dimensional array
x = LBound(ary) and y =UBound(ary)
or if more that one dimension
x = LBound(ary,1) and y =UBound(ary,1)
x = LBound(ary,2) and y =UBound(ary,2)
Subtract if necessary to find number of rows
num = UBound(ary) - LBound(ary) + 1
---------------------------------------------------------------------------------------------------------------------
Paul
Remember: Tell us WHAT you want to do, not HOW you think you want to do it
1. Use [CODE] ....[/CODE ] Tags for readability
[CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
2. Upload an example
Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
3. Mark the thread as [Solved] when you have an answer
Thread Tools (on the top right corner, above the first message)
4. Read the Forum FAQ, especially the part about cross-posting in other forums
http://www.vbaexpress.com/forum/faq...._new_faq_item3
Thank you!
Posting Permissions
Reply With Quote