VBA to insert row number.

[fmanfisher]

Hello All!

I need some help...

I have four columns in a spreadsheet:

Time In (A1)
Name (B1)
Company (C1)
Time Out (D1)

Currently, I have it set to where when I type a Name in the Name Column, the time automatically generates in the Time In Column, using this code...

Please Login or Register  to view this content.

I want to add a new row labeled Wristband #.

So the rows would now be:

Wristband # (A1)
Time In (B1)
Name (C1)
Company (D1)
Time Out (E1)

I want the same thing to happen as the time, except for the ROW NUMBER to automatically appear in the Wristband # Column.

EXAMPLE

I type "John Doe" in C142, "11:42 AM" Appears in B142, and then "142" Appears in A142.

I use the row number to assign wristbands to people, and when I sort the employees they don't always appear on the row they started on; which makes their wristband number different than their new row number. This way, I could sort them in alphabetical order, time-in, and their Wristband number would still be the same; even though the row number has changed.

Can someone help me make this work?

[DBY]

Hello
Maybe something like the following code would work for you:

Please Login or Register  to view this content.

Hope this helps.
DBY

[fmanfisher]

Hello
Maybe something like the following code would work for you:

Please Login or Register  to view this content.

Hope this helps.
DBY

Thanks for the quick response!! I am getting a runtime error," Application-defined or object-defined error"

I'm not sure what's wrong. Thank you!

[DBY]

Sorry, I can't replicate that error on my test workbook, it seems to work ok. For the Lrow variable I do reference Sheet1, that's not needed but I don't think that accounts for the error you're getting. Can you upload a sample file with the error?

[fmanfisher]

Sorry, I can't replicate that error on my test workbook, it seems to work ok. For the Lrow variable I do reference Sheet1, that's not needed but I don't think that accounts for the error you're getting. Can you upload a sample file with the error?

I tried attaching it, hopefully it works.

[StevePM]

Try this. I have inserted a line into your existing code which writes the row number in column C.

Please Login or Register  to view this content.

[fmanfisher]

Try this. I have inserted a line into your existing code which writes the row number in column C.

Please Login or Register  to view this content.

That is giving me the same error as before

[fmanfisher]

That is giving me the same error as before

I got it! I accidentally changed the offset to be - 2 instead of - 1 thank you so much!!

[DBY]

Hi
In this row you have:

Please Login or Register  to view this content.

It should be:

Please Login or Register  to view this content.

You had 1 up. It should be letter L and UP

DBY

[StevePM]

I got it! I accidentally changed the offset to be - 2 instead of - 1 thank you so much!!

No problem, I'm glad to have helped.