Excel Question: Can you have an automatic count... 1

[Kurti]

A question has been asked of me and I just can't seem to get the answer.

A friend of mine asked me if it was possible to have an excel sheet template, to count like #1, #2, #3, etc in a single cell, each time the excel sheet is open?

 

[xlbo]

Only via code
You would place this in the workbook open event:

Sheets("Sheet1&quot.range("A1&quot.value = sheets("Sheet1&quot.range("A1&quot.value + 1

AFAIK (and I'm pretty darn sure of this), there is no way to do this without code

Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde

 

[xlhelp]

Geoff,

Very simple and effective. A star for you.

Here I was thinking of some really complicated ways to do this.

"Mind is like a parachute. Works well when opened."

 

[Kurti]

Where does this go again? Where do I find the Workbook Open event?

 

[xlhelp]

I take it, you have it already solved under another forum.

"Mind is like a parachute. Works well when opened."

 

[Kurti]

Yes, it was solved on another forum. I ended up posting it there first.

But, thank you for helping me out, I ended up using your code sample above.

 

[xlbo]

So do you still need to find the workbook_open event ??

Rgds
Geoff
Si hoc legere scis, nimis eruditionis habes

 

[Kurti]

Thank xlbo, but no you guys helped me out on this problem and I thank you.