timer position error

Hello

i have count-up timer in my excel
in VBA CODE i choose K10 box to be the position for the timer
1.png

if i add or remove cells, timer will cause error bcoz its not adjustable
2.png
3.png

i already have table1 , so how can i link the timer with the table , so if i add or delete rows, timer go up and down without error

is that possible?

this my module code

Please Login or Register  to view this content.

thanks

Hi there,

Create a Named Range (e.g. ptrTimer) which refers to Cell K1 and use that Named Range (instead of [K10]) in your VBA code.

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

Regards,

Greg M

Hi again,

Many thanks for your very prompt feedback and also for the Reputation increase - much appreciated

You're welcome - glad I was able to help.

Best regards,

Greg M