I have a procedure that deletes all rows in a table, and I have another that adds a row. The problem is when I run DeleteAllRows and then AddRow immediately after, it doesn't work the first time. It only works on the second run.
Why is this and what is the solution?
Please Login or Register to view this content.Please Login or Register to view this content.
This will give you a better understanding...
You are in fact wanting to add data to the first empty row...
listrows.add references available empty row...
Please Login or Register to view this content.
Last edited by sintek; 04-21-2022 at 05:21 AM.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
I can see what's happening now, but I don't want to add any data to the table. I just want AddRow to add a second body row first time.
......Processing....
Imagine that even though the table looks to have a row it hasn't, with that in mind when you run it the first time it adds a row but you don't see it. It is only when you add the second row that you see the animation of the new row being added.
You can see that by running Sintek's code but if you want the first row to remain blank then maybe a slight change like:
Please Login or Register to view this content.
If things don't change they stay the same
Manipulated....
Please Login or Register to view this content.
Statto, this is an optical illusion.
When you delete all the rows of the table it has no rows, even though you see the first row on the sheet. This empty row can be called the " encouragement row". I think this is even better illustrated by the code below.ArtikPlease Login or Register to view this content.
Thanks for rep + ... Glad to have helped...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks