How to write reference to Table in vba
Dear Sirs
I have a problem to write reference to Table.
Normally with a range I would write looping "For Next" like that:
how to write it if I need to check rows in Table1
Please Login or Register to view this content.
I tried things like: for i=1 to Table1.rows.count and many similar comibnations and nothing works.
I means for me I need to get educated in this field. Please help
MODERATOR COMMENT: Code Tags added. Please use them in the future.
Last edited by alansidman; 06-25-2020 at 11:58 AM.
Hi Flowerski,
Try something like below ... By the way, if you're working with tables & VBA, I think you can click HERE for more details
Please Login or Register to view this content.
Last edited by nankw83; 06-25-2020 at 03:26 PM. Reason: Added a link
If I was able to help, you can thank me by clicking the * Add Reputation under my user name
Thanks. Your respond is helpful. THanks for valuable link.
What it is Code Tag? Moderator asked me to use it. What is that?
Glad I could help. Regarding code tags, when you post any VBA code it is easier for the forum members to read so you've been asked to insert the code tags which creates the box that you see my post where the code is located in. Easiest way to do it is select the code you have then click # & it will insert it for you. You can read more about it HERE
If the provided solution takes care of your original question, please mark this thread as 'SOLVED' from the Thread Tools at the top menu & consider adding Reputations to those who have helped by clicking the star under their usernames
FYI - You can also refer to table in following manner.
Though in general, I'd go with nankw83's approach of using ListObjects().Please Login or Register to view this content.
This will allow you to access methods and properties that belongs to ListObject. Ex: DataBodyRange, ListRows.Add, Resize etc
Edit: Note that 1 is used to start from first data. Use 0 to start from Header row.
"Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something."
― Robert A. Heinlein
Thank you very much
You are welcome and thanks for the rep.
Dear nankw83, I have read the link which supposed to explain me what is Code Tag. I still do not get it. Maybe one day I will understand. Thanks anyway.
Code tag is used to block code into more readable format separate from normal text.
[Code] is used before the code and [/Code] after the code.
This can be done by selecting your VBA code string, then pressing "#" button found at top section of text editor area.
0.JPG
Thanks, hopefully I will remember that. Take care
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks