Hell all,
I'm using a Table to Save the data for a New Crew Member using the code below. The problem is the Table does NOT Auto Expand to add the new Row of info.
I believe the Bold portion of code below needs to refer to the Named Table. I don't know how to correctly address that.
Of course I could very wrong and am missing it completely.
V/r,
Please Login or Register to view this content.
Jim
Try this:
Please Login or Register to view this content.
Visit : Excel & Macro
https://www.youtube.com/@CursosDeExcelyMacros
Dante,
Thank you for looking. I seems as when I run the Crew_SaveNew() MACRO with your suggestion. The New Crew Data simply overwrites an existing entry and add one line to the Table.
Does it make a difference that the table Header starts in Row 7?
It does appear that the last row that is over written is 7 Rows about the last row.
I tried to adjust my original:
to this:Please Login or Register to view this content.
Of course neither seem to do the trick.Please Login or Register to view this content.
V/r,
Jim
Last edited by sorensjp; 08-31-2020 at 11:57 PM.
Hello,
I was able to find a Thread on Mr. Excel that worked. Someone (brighter than me) figured to resize the Table Range after the Data is transferred to the Table.
Thank you all that looked. V/r,Please Login or Register to view this content.
Jim
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks