Issue with Cell Numbering

[jpcsolutions]

Hello All...

Please see the attached picture.

What I have are the cell row numbers down the left. They don't line up with what I need, so at cell #4, I've started my first row of data. What I'm trying to do is have the code you see below, fill the first empty row with the data entered from the Userform. However, it sees Row 4 with data from the new row number I put, and the Userform is placing the data at Row 79, which is the first row without any data.

Please see the code, and let me know what I can do to tweak it...

Private Sub cmdSubmit_Click()
Dim NR As Long

Please Login or Register  to view this content.

If there's another way I can phrase this, please let me know.

Thanks,

Jared

[wamp]

Try this

Please Login or Register  to view this content.

[jpcsolutions]

Hey Wamp...

It worked, however, I'd like the first row to label itself as 1 (for Row 1), but it shows up automatically as '0'... I've read over the code and I don't see how to adjust that. Any ideas?

Thanks,

Jared

[wamp]

not quite sure I understand what you mean.. according to your example picture, you start at Row number four.
I therefore put

Please Login or Register  to view this content.

(which should make the first number "1")

if, however, your first editable row is number 3; then you should alter it to

Please Login or Register  to view this content.

[jpcsolutions]

Hey Wamp,

I've attached (see Row_Numbering attachment) an example of what I'm talking about... the cell numbering automatically starts with "0" and I'd like to see it start with "1".

I'm sorry I wasn't very clear in my last post.

Thanks,

Jared

[jpcsolutions]

Thanks for the help, Wamp.

[jpcsolutions]

Solved... I'm not able to solve it the way we used to.