i'm having problem with this code, because if i copy paste straight to the sheet and use the form to fill in the data, but it doesn't paste the data below.
as you can see the test and the data doesn't paste below it.
Capture.PNG
Please Login or Register to view this content.
Last edited by noelcjf; 03-27-2024 at 11:26 PM.
hii
i am glad to help you. check the code ensure that it was correctly identifies that last row data is present and than paste new data .first you want check your code that right or wrong. if right then do other process
Stock James
THANKS
it work properly when the sheet is empty, if i paste the old data in and fill in the form then i check back, but it still doesn't paste to the next empty row
Last edited by AliGW; 03-28-2024 at 03:02 AM. Reason: Please don't quote unnecessarily - use the Quick Reply button instead.
Step debug the code.
While you are in vbe:
Click somewhere on the code and hit F8.
As you hit F8, the code executes one line.
Keep doing until you pass the line of
Then you can hover the cursor over to variable iRow(not click) and see what value it is.Please Login or Register to view this content.
If the formula in B:AD is not resulting "", it counts it.
Anyway, better upload a workbook.
iRow = 0 is shown when i hover to iRow
Last edited by AliGW; 03-28-2024 at 03:02 AM. Reason: Please don't quote unnecessarily - use the Quick Reply button instead.
Are you sure you past that line?
0 is not possible.
Do you have On Error Resume Next in the top of the code?
If so, you will need to delete that line.
iRow = 65460 as shown after i pass it
sorry i stop at iRow thats why
Last edited by AliGW; 03-28-2024 at 03:44 AM. Reason: Please don't quote unnecessarily - use the Quick Reply button instead.
OK, then I need to see the formula.
It is not returning "".
I fixed it and thank you for your help!Originally Posted by jindon
You are welcome, and glad you fixed it.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
i knew this reputation system
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks