Using a variable in multiple macros

[cdex]

Hello, I am trying to get a counter to add 1 every second to a cell. I want that cell to be the active cell at the time of starting the macro but allow you to select other cells while it is running. This is the code i have got so far:

Please Login or Register  to view this content.

Any help would be greatly appreciated.

Thanks

[Norie]

Try this.

Please Login or Register  to view this content.

[cdex]

Thanks that is perfect.