Time Clock Log Error

[Billy Spivy]

Hello,

I have 2 sets of IDs for each employee and I'm trying to remove the EMP101 for instance and just use the 3 digit ID number. See highlight columns and cells for EMP #s.

I already removed them from the 'Time Clock Log' sheet but now the 'Clock In/Out' code on the 'Switchboard' goes to debug mode.

Can someone please help?

Thank you very much,
Billy

[xladept]

Try replacing:

Please Login or Register  to view this content.

with:

Please Login or Register  to view this content.

[Billy Spivy]

That worked great thank you so much. One little 'x' was all it took.

Just wondering can I remove?

Empx = "EMP" & Format(Emp, "000")

[xladept]

You're welcome and thanks for the rep!

Yeah - I think you can get rid of that - you're not using it!

[Billy Spivy]

Eliminated with no errors thanks again!