Data placement into Cell going to wrong row

[snuffnchess]

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???

[Greg M]

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

[snuffnchess]

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.

[Greg M]

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

[snuffnchess]

That is so odd.

I have highlighted in Red the code that References this tab... maybe it will help??

Please Login or Register  to view this content.

I just tried it again, and added "Testing 1" to the form. When it adds the info to the other tabs, it puts it in the correct place.

When it adds it to the "Data" tab it puts the info in row 14 instead of row 6. Before Running the userform, i highlighted from Row 6 Down to the end of the worksheet and cleared all contents just to make sure there was no data in those cells.

[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

[snuffnchess]

Greg

If you go to the Data worksheet you will see where it is not properly working

[FDibbins]

snuffnchess, please to not use the REPORT button to bring attention to your thread
(FWIW, only mods and admin can see reported threads anyway)

[torachan]

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

[Greg M]

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