Data placement into Cell going to wrong row

I am trying to figure out why data in going into the wrong row with this code.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I would expect start seeing data in C6 of the "data" tab... but instead it is starting in cell C10.

Any thoughts???

Hi there,

This is a bit difficult to understand, because the code you posted cannot be located anywhere in the VBA CodeModules of the workbook you attached, and none of your worksheets is named "data". Are you sure that you attached the correct workbook?

From your description of the problem (Cell C10 instead of Cell C6), I'd guess that four cells in Column A appear to be empty but actually contain blank characters.

Hope this helps.

Regards,

Greg M

Hi there. The code is not in the modules, but instead in the UserForm. if you double click on the "add" button you will see it there. I did check the cells in those rows, and unless i am missing something, could not locate anything that is in the rows that could be setting off this.

Hi again,

I used the VB Editor "Find" command to search the Current Project for the texts "dt.Cells" and "dtRow" but was unable to locate them.

On a more encouraging note, when I used the "Add Client" button to insert new records on the "ClientDB" worksheet, the new records were inserted in the correct (i.e. the next empty) row.

Hope this helps,

Regards,

Greg M

Hi again,

Thanks for your feedback.

Two points:

1 - the workbook you posted (data.xlsm) is not the same as the workbook (CLwork.xlsm) you posted previously - no wonder I couldn't locate "dt.Cells" or "dtRow" in it!

2 - when I used the "Add Client" button to insert new records on the "ClientDB" worksheet, the new records were inserted in the correct (i.e. the next empty) row.


Hope this helps with the debugging process.


Regards,

Greg M

You are getting confused with your row counters and which sheet they refer to.
Attachment 622994
torachan

Hi again,

Your code is assigning an incorrect value to the variable "dtRow"

If you make the highlighted changes to your code the new entries will appear on the correct rows:

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards,

Greg M