Ticket Counter

Hi, I was wondering if there a way of Excel using the active cell in a formula? I want the cell B1 to display whatever value is in the active cell.

I've attached the workbook as an example. Each time the 'button' is clicked on the active cell moves down one row. I want the number displayed to be that of the active cell (increase by one each time).

Thanks in advance for any help.

Hi,

Try this one.

Hi, thanks for the response. The macro is increasing the number by one as required but every time the error message comes up?

Run time error 28
Out of stack space

Hi,

Try this one:

Perfect thank you.