LinkBack URL
About LinkBacks
HI GUYS
when i transfer data from userform to sheet2 it begins in row136 not row2 i no know why
[ATTACH]626972
HI GUYS
when i transfer data from userform to sheet2 it begins in row136 not row2 i no know why
[ATTACH]626972
I suspect you had something in A136 initially.
Everyone who confuses correlation and causation ends up dead.
This problem occurs only when I choose a ready-made table form from a design exel .
When I design the table myself, the posting is done normally
So why post a workbook that doesn't have a Table in it?
If you have a table, you should be using the ListObject.Listrows.add method to add your data, and not creating a table with a load of blank rows already in it. The End(xlup) will stop at the bottom of your table regardless of whether the last row has anything in it.
can you see my attached file and changed my code because i am new in vba if you don't mind
Does your real file have a table in it?
Yes, i have a simple table
Then you might use something like this:
Please Login or Register to view this content.
actually , i appreciate your efforts but , still the code works from row136???
Your table should not have any blank rows in it. The code will add rows to the table as needed.
but, in the beginning it must be the table is blank to fill datas in rows
Working example.
You start with the first table row (this is row 3 in your excel file),the table will do the rest.
Don't add frames,colors,rows... The table does this itself
To use my posting code, look at the textbox names.
Click the * Add Reputation below to say thanks.
thanks now it does work
Please mark as solved ...thnx
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks